1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SELECT
_O.ORDE_id as id,
_O.ORDE_paymode as paymode,
_O.ORDE_giftpack as giftpack,
_O.ORDE_placeddatetime as placeddatetime,
O.PEOP_name as orderername,
O.PEOP_firstname as ordererfirstname,
O.PEOP_address as ordereraddress,
O.PEOP_zip as ordererzip,
O.PEOP_city as orderercity,
O.PEOP_country as orderercountry,
O.PEOP_mail as orderermail,
D.PEOP_name as deliveryname,
D.PEOP_firstname as deliveryfirstname,
D.PEOP_address as deliveryaddress,
D.PEOP_zip as deliveryzip,
D.PEOP_city as deliverycity,
D.PEOP_country as deliverycountry,
D.PEOP_mail as deliverymail
FROM
ORDERS _O
LEFT JOIN
PEOPLE D ON D.PEOP_id = _O.ORDE_PEOP_delivery
LEFT JOIN
PEOPLE O ON O.PEOP_id = _O.ORDE_PEOP_orderer
WHERE
ORDE_id = 1 |
Partager