left join

Lizard5396426

I have a problem using a mysql left join.

I have 2 tables - book and date.

The date table has a list of dates with am and pm values for a full year.

The book table contains a record of which dates have been booked.

I want to show all the values in the book table with all the values in the date table. Where there is no value in the book table, i wanta null record from the date table.

I've tried what is suggested in the o'rielly managing and using mysql book, but get error 1066, which is something to do with duplicate values.

I hope this is enough information.

tomhath

Posting the query would've helped. The database might be having problems if you have the same column name in both tables. Also the table name of "date" looks like it could be a problem, date is a reserved word.