4 Jan
2001
4 Jan
'01
11:37 a.m.
hi Phil,
The left join is a notation that says to get all records from the left hand side of the join and only those records where the criteria matches from the right hand side.
It is btw a part of most RDBMS engines I've ever used, so it's not that unusual a syntax.
You can also do something similar by using unions. thanks a lot for that,
do you have any suggestion (principally) how this union would look like thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com