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
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
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 but tableA.id is not found on tableB.idA
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
LEFT JOIN tableB ON