When it comes to JOINS, there are 3 flavors in MySQL: LEFT, RIGHT, and
INNER.
This is an example of how to join two tables a and b:
SELECT (some columns) FROM a XXX JOIN b ON (some logical comparison) WHERE
(some overall condition)
Behind the scenes, the data engine creates a virtual table tha
Brilliant !
thank you so much!
only one more question: INNER JOIN is not a good choose because it
lists only the record with a matching ON clause, and this is the only
difference between LEFT and INNER, correct?
thanks again,
Giulio
Il giorno 29/lug/04, alle 16:03, [EMAIL PROTECTED] ha scr
Assume you want to check the availability of a room between two dates. You
only want to get the rooms that are available for the entire time from
@startdate to @enddate
set @startdate='some_start_date', @enddate='some_end_date'
SELECT r.room_number, r.room_type
FROM rooms r
LEFT JOIN reservatio
