I have a table I need to update with a value from two other tables. What's the syntax? Obviously not the same as SQL Server. I may have figured out the need for a subquery, but how do I link the value returned from the subquery to the table being updated?

Table 1 - needs to be updated
Table 2 - links to Table 1
Table 3 - links to Table 2 and has the value needed for the update

' here's a stab at it but it's not quite right:
UPDATE Table1
SET myDateDueValue = (SELECT P.DATEDUETOREP from Table2 U, Table3 P
WHERE P.PROPOSALNUMBER = U.RP_ProposalNumber AND U.RP_PROPOSALNUMBER <> 0) SQ
WHERE REQUESTID = SQ.REQUESTID;