quote:

---

Originally posted by johnwayne77

hello!

i'm implementing an e-commerce system to distribute key codes.

right now i'm thinking of a sql syntax to do the following:

i have a table: orders

here i have the orders_id field (unique for each order placed)

with this orders_id field there may be more than one products ordered therefore in the products_id field i can have the following situation:

orders_id: 101
products_id: 13
orders_id: 101
products_id: 43
orders_id: 101
products_id: 1

so i have three rows with the same orders_id but different products_id

now i want to grab the value of these products_id for the specified orders_id (p.s. i can provide the orders_id value already)

any ideas? i'm a little stuck on this..

thanks

---

SELECT order_id,product_Id
FROM products
WHERE order_id=@Order_id

SELECT o.*,p.product_id,p.productname,...
FROM orders o
INNER JOIN products p
ON p.order_id=o.order_id
WHERE o.order_id=@Order_id