Hi all
How can I translate the following sql into one using LEFT OUTER JOIN on the
tables TCity and TStreet? This to get all records of TClient including the
once that do not have a relation with TCity or TStreet.
SELECT cl.*,
sub.Type,
c.City,
s.StreetName
FROM TClient cl,
TSubs sub,
TCity c,
TStreet s
WHERE cl.ID = sub.ID
AND cl. StreetName = s.ID
AND cl. CityName = c.ID
AND sub.SubType IN(1,2,4,5)
AND cl.Active = true
Thanks for your help
John
_______________________________________________
NZ Borland Developers Group Offtopic mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/offtopic
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
