I have this two tables:
uID | NAME | 1 | N1 | 2 | N2 |
rID| TEXT | DATE | USER 1 | awda | 2015-02-16 | 1
And I try to get all users with
raports.DATE = 2015-02-16 or users for which raport with this date doesn't exist.
I try something like this:
SELECT * FROM `users` LEFT JOIN `raports` ON uid = user WHERE (usr_id in ('1', '2'))