3 table comparitive join...

wxdqz

New Member
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
 
Back
Top