select * from product INNER JOIN client where product.clientid=client.registerid and client.registerid=4select * from productdeliverd where productid=4