At 06:32 AM 1/1/03 -0500, David T-G wrote:
The reason I chose LEFT JOIN are:I still don't get what a left or right or outer or inner join is...
o You get better control over how the query is executed.
o Values from the first table are returned even if there is no associated entry in the second table. For eaxample if no building or room was set on an entry in my previous query, the rest of the data will still be returned.
Do you know of any (on the web) which will give me the background?
http://www.devshed.com/Server_Side/MySQL/Join/page1.html http://www.devshed.com/Server_Side/MySQL/Normal http://www.devshed.com/Server_Side/MySQL/SQLJoins/page1.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
