Search Query

[arjandha]

SELECT *
FROM Item I, LeadSinger S
WHERe I.upc = S.upc AND (I.title like '%Some Search String%' OR I.category like '%Some Search String%' OR S.name like '%Some Search String%');

//Some search string is entered by user in gui.