SELECT c.ENTNAME,ec.ENTNAME,c.REGNO,c.UNISCID,c.NACAOID
FROM c1 c
LEFT JOIN c2 ec ON c.ID = ec.ID
WHERE c.ENTNAME LIKE '%test%'
or c.REGNO LIKE '%test%'
or c.UNISCID LIKE '%test%'
or c.NACAOID LIKE '%test%'
or ec.ENTNAME LIKE '%test%'
limit 0,10
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/38020.html
標籤:疑難問題
