How combine these queries

Hi All,
Here are queries,
"select * from product WHERE LastName like concat(?, '%')"
"Select concat(FirstName, ' ' , LastName) as FullName, Product_id from Customer join […]

See original post by invalid@example.com (Rozard Dard)