Recent content by joebloggs2004

I managed to figure them out. Well, I think so. Thanks anyway :)

I've come up with SELECT C.clientName, RL.productNum, RL.qtyRequested FROM CLIENT AS C, REQUEST_LIST AS RL WHERE C.clientNum = (SELECT clientNum FROM STOCK_REQUEST) AND RL.requestID = (SELECT requestID FROM STOCK_REQUEST) ORDER BY C.clientName, RL.productNum; But I keep getting the message "At...

Ok, I've done that, but it uses inner joins which i've been told not to use. I've been told to use SQL joins instead. How do I make a SQL join between the 2 tables? Its actually Stock_Request that has a common attribute "clientNum" with Client and Stock_Request shares a common attribute with...

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...

Whats wrong with this statement?? SELECT P.productNum, P.description, PL.locationNum, PL.quantityOnHand FROM PRODUCT AS P, PROD_LOCATION AS PL WHERE PL.quantityOnHand > 0 ORDER BY P.productNum, PL.warehouseNum, PL.locationNum GROUP BY P.productNum, P.description, PL.locationNum...

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...