Re: Question about not required fields
- From: Yannis <None@xxxxxxxxxx>
- Date: 30 Aug 2005 00:14:56 -0700
"Norman" <norman@xxxxxxx> wrote in news:4313ac76@xxxxxxxxxxxxxxxxxxxxxx:
> SELECT T1.*, T2.* FROM T1, T2
> WHERE T1.F = T2.F
> ORDER BY T1.F
>
This SQL statement is the same with
SELECT T1.*, T2.* FROM T1
INNER JOIN T2 ON T1.F = T2.F
ORDER BY T1.F
What you need is something like
SELECT T1.*, T2.* FROM T1
LEFT JOIN T2 ON T1.F = T2.F
ORDER BY T1.F
The above statement will return all the rows
from T1 but not all the records from T2 will
be returned unless all the records on T2 are
linked to T1.
Regards
Yannis.
.
- References:
- Question about not required fields
- From: Norman
- Question about not required fields
- Prev by Date: Re: TADOconnection not found
- Next by Date: MYSQL solution for "Row cannot be located, values have changed since it was last read."
- Previous by thread: Question about not required fields
- Next by thread: MYSQL solution for "Row cannot be located, values have changed since it was last read."
- Index(es):
Relevant Pages
|
