Answers for "mysql select data not in multiple tables"

1

mysql select where not in multiple tables

SELECT inactive.id
FROM inactive
WHERE NOT EXISTS (select null from renamed where renamed.id = inactive.id)
AND NOT EXISTS (select null from returned where returned.id = inactive.id)
Posted by: Guest on July-05-2021
1

select multiple tables mysql

SELECT t1.dt2, t2.dt4, t2.dt5, t2.dt3 #get dt3 data from table2
FROM table1 t1, table2 t2 -- Doesn't need to have t1, or t2
WHERE t1.dt2 = 'asd' AND t2.dt4 = 'qax' AND t2.dt5 = 456
Posted by: Guest on September-19-2021

Code answers related to "mysql select data not in multiple tables"

Browse Popular Code Answers by Language