I have two tables(A,B), one of them initially empty
I want to do a select from A if B is empty or if B.field1 does not have a specific value or is NULL.
So something like
How can one do that in mysql?
I want to do a select from A if B is empty or if B.field1 does not have a specific value or is NULL.
So something like
Code:
SELECT A.field1, A.field2 FROM A JOIN B ON A.field1=B.field1 WHERE [B is empty]
OR B.field2 !=A.field2
How can one do that in mysql?