Re: [SQL] Difficulties with a master-detail query

2005-09-23 Thread Bruno Wolff III
On Mon, Sep 19, 2005 at 20:29:40 +0300, "Milen A. Radev" <[EMAIL PROTECTED]> wrote: > > I would like to get all employees, who speak two specified languages > (say german and french). The following query gives me that, bu I don't > like it (see for yourself): > > > SELECT > ?.employee_id, >

[SQL] Difficulties with a master-detail query

2005-09-22 Thread Milen A. Radev
Hi, list! You have most probably met the same problem: I have a master table, describing the objecs I'm interested in - let's say employees. I have a details table, defining all possible values of one of the properties of the objects - let's say languages spoken. And of course I have a table desr