RE: Performance Problem - LEFT JOIN

2002-07-25 Thread Barnali
e Cc: [EMAIL PROTECTED] Subject: Re: Performance Problem - LEFT JOIN Guilherme wrote: >I have 3 tables tableA, tableB and tableC and the fields tableA.id, >tableB.idA and tableC.idA. >I'm using this query (bellow) to call information from the database that has >in tableA

Re: Performance Problem - LEFT JOIN

2002-07-25 Thread Egor Egorov
Guilherme, Thursday, July 25, 2002, 4:18:13 AM, you wrote: G> I have 3 tables tableA, tableB and tableC and the fields tableA.id, G> tableB.idA and tableC.idA. G> I'm using this query (bellow) to call information from the database that has G> in tableA but tableA.id is not found on tableB.idA and

Re: Performance Problem - LEFT JOIN

2002-07-25 Thread Ralf Narozny
Guilherme wrote: >I have 3 tables tableA, tableB and tableC and the fields tableA.id, >tableB.idA and tableC.idA. >I'm using this query (bellow) to call information from the database that has >in tableA but tableA.id is not found on tableB.idA and tableC.idA. > >SELECT tableA.* > FROM tableA