SQL query required

[Lost User]

Dear Friends, I got two tables: order and orderDetails Order table is:

OrderId CustomerCode OrderDate
1 55 2/12/2004
2 55 3/12/2004
3 56 4/15/2004
4 57 4/16/2004

OrderDetail table is:

OrderId ProductId Quantity
1 131 12 Litres
1 157 13 KGs
1 111 12 MT
2 131 19 litres
3 155 12 dozens

I want SQL query such that: I want to print all the productId placed by customerCode 55 and orderdate i.e result contains following columns: CustomerCode, OrderDate, ProductId, Quantity For customer code 55. What can be the query ??

[raj_sarna]

does this sql statement help u in any way : Select CustomerCode, OrderDate, ProductId, Quantity From [Order] a Inner Join OrderDetails b On a.OrderID = b.OrderID Where a.CustomerCode = 55 Try not using Keywords for Table/Column names (like Order). Parshu

[Colin Angus Mackay]

parshu21 wrote: Try not using Keywords for Table/Column names (like Order). That's good advice - It can get confusing.

---

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar Coming soon: The Second EuroCPian Event[^].