And if the command is given as below :
SELECT Table1.Name, Table1.Address1, Table1.Telno, Table2.Address1, Table2.Telno FROM Table1 RIGHT 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 | NULL | NULL | NULL | "4th Floor, RED Apartments" | "7897246814" |
From the above you will seee that the all records having field names stated in the command from the table on the right hand side of the clause "RIGHT 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 appear as "NULL".
For more information and tips about sql, please visit http://www.freeecommersetips.com/Software_tips_sql_part_4.asp
|
|
|
|
|
|