Answer the question
In order to leave comments, you need to log in
How to do a JOIN on another table that doesn't have a value?
There are two tables:
Tell me, please, how to make a query to get:
Something like this comes to mind:
SELECT t1.id FROM `table1` as t1
LEFT OUTER JOIN `table2` as t2
ON t1.id=t2.id_table1
where t2.le_va=1
order + limit
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question