An SQL join clause combines records from two or more tables or views.

learn more… | top users | synonyms

4
votes
2answers
90 views
+50

MySQL: delete…where..in( ) vs delete..from..join, and locked tables on delete with subselect

Disclaimer: please excuse my lack of knowledge about database internals. Here it goes: We run an application (not written by us) which has a big performance problem in a periodic cleanup job in the ...