Search results

I'm having trouble with these 2 queries: A sorted list showing each product requested on each client stock request. Show client name, product number and quantity requested in name and then product order.SELECT C.clientName, RL.productNum, RL.qtyRequested FROM CLIENT AS C, REQUEST_LIST AS RL...

I have some SQL query problems, which I can't figure out exactly where the problem is. SELECT RL.productNum, RL.qtyRequested, PL.quantityPicked, (RLqtyRequested – PL.quantityPicked) FROM REQUEST_LIST AS RL, PICKING_LIST AS PL WHERE RL.productNum = (SELECT productNum FROM PICKING_LIST);I think...