Subject | Re: [firebird-support] Question on JOINS |
---|---|
Author | Radu Sky |
Post date | 2006-01-24T12:35:25Z |
Between these two statement , which one is faster?
SELECT C1,C2... FROM TableA
JOIN TableB ON TableA.PK=TableB.FK
or
SELECT C1,C2... FROM TableA
LEFT JOIN TableB ON TableA.PK=TableB.FK
Both queries return the same result, FK is the Foreign key for PK
TIA
Radu
SELECT C1,C2... FROM TableA
JOIN TableB ON TableA.PK=TableB.FK
or
SELECT C1,C2... FROM TableA
LEFT JOIN TableB ON TableA.PK=TableB.FK
Both queries return the same result, FK is the Foreign key for PK
TIA
Radu