Sarah, I can't thank you enough, for your help, you are great, the "HAVING" clause is working perfectly. Thank you so much
Update.... I used your query and added the added where clause, it works if I enter CustomerId or PersonId as input. How I can enter the full name...
My apology, it was typing mistake, I was just typing it from my head. I didn't clear it properly Table names are "Customer" and "Product" Customer...
Hi All, Here are queries, "select * from product WHERE LastName like concat(?, '%')" "Select concat(FirstName, ' ' , LastName) as FullName,...
Separate names with a comma.