sql - Only run query for TableB if TableA is not empty -


i have script deletes data tableb , inserts data tablea tableb .

how can perform delete * table b query when there data in tablea?

you use exists operator:

delete table_b exists (select * table_a) 

Comments