Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by beeboroach
-
MS Access SQL Subquery Question
Sorry if I didn't clarify, I was just trying to see how to use subqueries in that instant. I know how to use joins, thanks for your input though!- beeboroach
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access SQL Subquery Question
NVM, I think I got it... SELECT PRODUCT.Product_Description, PRODUCT.Standard_Price FROM PRODUCT INNER JOIN Order_line ON PRODUCT.Product_ID = Order_line.Product_ID WHERE PRODUCT.Product_ID IN ( SELECT Order_line.Product_ID FROM Order_line Where Order_line.Product_ID=PRODUCT.Product_ID )...- beeboroach
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access SQL Subquery Question
I need to use a subquery to create a list that shows the description and price for all products that were ever ordered. It should not show products that were never ordered. This is what my relationships look like: http://s15.postimage.org/lfxn95hvt/test.png Here's what I started with: SELECT...- beeboroach
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
