Greetings,
I have never used this property and now have the need:
Have a join SQL statement and be able to update the main table in the SQL
statement.

The SQL Statement looks like this:

SELECT
T.ID, T.ODID, T.ODSEQ, T.COMPANY, T.DIVISION, T.ORDERNO,
T.SUFFIX, T.PRODID, T.ITEMNO, T.STATUS, T.RECSOURCE, T.RECTYPE,
T.SHIPATEXT, T.SHOWONRPT, T.COMMENT, T.ASKINGPRICE, T.CLASS1, T.CLASS2,
(SELECT PRODDESC FROM SP_GET_PRODDESC(T.PRODID)) AS PRODDESC,
OD.FOBPRICE, OD.DLVDPRICE
FROM TRANSIT_INVENTORY T
LEFT OUTER JOIN ORD_DTL OD ON OD.ID = T.ODID AND OD.SEQ = T.ODSEQ
WHERE T.COMPANY = :COMPANY AND T.DIVISION = :DIVISION AND
T.ORDERNO = :ORDERNO AND T.SUFFIX = :SUFFIX

=======================================
I would like to be able to update the Transit_Inventory table.

Any clues/examples would be GREATLY appreciated.

Kevin