Continued from last page .....
And if the command is given as below :
SELECT Table1.Name, Table1.Address1, Table1.Telno, Table2.Address1, Table2.Telno
FROM Table1 LEFT OUTER JOIN Table2 ON Table1.Name = Table2.Name
The above command will change give the output as follows :
|
Results-Fields
|
Tabel1.Name
|
Tabel1.Address1
|
Tabel1.Telno
|
Tabel2.Address1
|
Tabel2.Telno
|
|
Record 1 data
|
"A.Symonds"
|
"Gr.Floor, ABC Apartments"
|
"5879879870"
|
"3rd Floor, UTV Apartments"
|
"4564897987"
|
|
Record 2 data
|
"M. Jones"
|
"3rd Floor, HTX Apartments"
|
"6548736843"
|
"Gr. Floor, AJH Apartments"
|
"4894465465"
|
Record 3 data
|
"G. Haynes"
|
"2nd Floor, JUI Apartments"
|
"4564654879"
|
NULL
|
NULL
|
From the above you will seee that the all records having field names stated in the command from the table on the left hand side of the clause "LEFT OUTER JOIN" are listed and only the condition satisfying record values of the fields given in the command are displayed. And if the condition is not satisfied the fields give the value "NULL"
For more information and tips about sql, please visit http://www.freeecommersetips.com/Software_tips_sql_part_3.asp
