Hi all...

I have to tables. One has a set of dates, the other a list of transactions. I want to be able to produce a set of dates which are not included in the transaction table based on an ID.

I have tried this

"SELECT date FROM SchoolDates NOT IN (SELECT date FROM Transactions WHERE ID='$id') ORDER BY date"

i have tried various combinations of the above but none seem to work, i am using php and a mySQL db.

can anyone help?

Thanks

Jamie