i tried this query
DELETE
FROM databa_vbphrase AS p1
USING phrase AS p1
LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
AND p2.languageid = -1 )
WHERE p1.languageid =0
AND p2.languageid IS NOT NULL;
and still get this error
#1146 - Table 'databa_vb.phrase' doesn't exist
DELETE
FROM databa_vbphrase AS p1
USING phrase AS p1
LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
AND p2.languageid = -1 )
WHERE p1.languageid =0
AND p2.languageid IS NOT NULL;
and still get this error
#1146 - Table 'databa_vb.phrase' doesn't exist
Comment