The SELECT c.E NTNAME, ec ENTNAME, c.R EGNO, c.U NISCID, citigroup ACAOID
The FROM c1 c
LEFT the JOIN c2 ec ON c.I D=ec. ID
Test the WHERE c.E NTNAME LIKE '% %'
Test or c.R EGNO LIKE '% %'
Test or c.U NISCID LIKE '% %'
The or c.N ACAOID LIKE '% % test'
The or ec. ENTNAME LIKE '% % test'
Limit of 0, 10