I am currently smacking my forehead into the top of my desk. Here's why!
I am trying to get a RIGHT JOIN to work:
SELECT table_two.times, table_one.dates
RIGHT JOIN table_two ON table_two.times = table_one.times
WHERE table_one.dates = '2004-04-14'
Now, I am trying to get a list of all the times from table_two, which is itself just a list of times from 9 am to 5 pm in half hour increments, with all matches from table one, such that if a time from table two does not show up in table one, in the result, the "table_one.dates" field should just be null.
Does this make sense?
Anyway, I am not getting the non-matches in the result set, as I should because I am using the RIGHT JOIN.
Make with the help please!