Re: [SQL] cross-table reference

2005-06-29 Thread Bruno Wolff III
Please keep replies copied to the list unless you have a specific reason not to. This lets more people potentially help you and lets others learn from the discussion. On Wed, Jun 29, 2005 at 14:09:16 +0530, Mukesh Ghatiya <[EMAIL PROTECTED]> wrote: > Hi Bruno, > > Thanks for the response. Ok, l

Re: [SQL] cross-table reference

2005-06-28 Thread Bruno Wolff III
On Wed, Jun 22, 2005 at 14:56:08 +0530, Mukesh Ghatiya <[EMAIL PROTECTED]> wrote: > Hi, > > I need to perform a query similar to > > SELECT table1.a.b.x table1.a.c.x from table1; > > > In this case "a" is an attribute in 'table1' and is a foreign key to > other table2 which has 'b', and 'c'

[SQL] cross-table reference

2005-06-27 Thread Mukesh Ghatiya
Hi, I need to perform a query similar to SELECT table1.a.b.x table1.a.c.x from table1; In this case "a" is an attribute in 'table1' and is a foreign key to other table2 which has 'b', and 'c' as attributes, which again are foreign keys to table3. Is there any simple way of doing this other t