I have three tables, and the second table relates the first and the third table together. I need to select all notices not that belong to a user that are not in any personal folders... here's what I have:
select distinct * from table1 left join table2 using (note_id) left join table3 using (folder_id) where table3.user_id=$foo and table2.note_id is NULL
This always returns and empty set.... Any idea?
This is MySql so no nested selects....
Thanks
select distinct * from table1 left join table2 using (note_id) left join table3 using (folder_id) where table3.user_id=$foo and table2.note_id is NULL
This always returns and empty set.... Any idea?
This is MySql so no nested selects....
Thanks