SQL-problem

[Filips Benoit]

Dear All,

Tables: ORDER, ORDER_PROPERTY relation ORD_ID = OP_ORD_ID

ORDER: ORD_ID, ORDT_ID, ORD_NAME, ....
ORDER_PROPERTY: OP_ORD_ID, OP_PRP_ID, OP_VALUE

I want a list ORD_ID, ORD_NAME, OP_VALUE of all orders with ordertype
(ORDT_ID) = 1
showing OP_VALUE for OP_PRP_ID = 144 and a blanc cell if property 144 is not
mapped for that order!

ORD_ID ORDT_ID ORD_NAME OP_VALUE
1 1 name1 12
2 1 name2 14
3 1 name3
4 1 name4 17
5 1 name5 22
6 1 name6
7 1 name7 54

Orders 3 and 6 has NO value for property 144 in ORDER_PROPERTY

Thanks,

Filip

[David Portas]

SELECT O.ord_id, O.ordt_id, O.ord_name, P.op_value
FROM Orders AS O
LEFT JOIN Order_Property AS P
ON O.ord_id = P.op_ord_id
AND P.op_prp_id = 144
--
David Portas
SQL Server MVP
--

[Filips Benoit]

Thanks,

"David Portas" <RE****************************@acm.org> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

SELECT O.ord_id, O.ordt_id, O.ord_name, P.op_value
FROM Orders AS O
LEFT JOIN Order_Property AS P
ON O.ord_id = P.op_ord_id
AND P.op_prp_id = 144
--
David Portas
SQL Server MVP
--