Hi Leon,

SELECT
a.primarykey,
a.order,
b.name,
c.description
FROM tableA a
LEFT JOIN tableB b ON (a.orderID = b.orderID)
LEFT JOIN tableC c ON (a.orderID = c.orderID)
FOR UPDATE

and set the dataset's KeyRelation property to "tableA".

HTH,
Markus