Thanks to those who answered my simple query. Answer is you can't do this directly in the update command. Just perform the required selection and update from that!, as from Martin Higham:
Select * from <table> where <colA> = num1 and <col2> = num2 Update selection set <colC> = num3 -----Original Message----- From: Warwick Bishop [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 February 2004 10:56 AM To: [EMAIL PROTECTED] Subject: MI-L SQL query, where on 2 columns Hi, I want to do an update, matching values based on two columns. i.e., update column C in table 1 where both columns A and B match in table 2. Cheers, Warwick _______________________ Warwick Bishop Water Technology P/L 8 Business Park Drive Notting Hill VIC 3168 Phone +61 3 9558 9366 Fax +61 3 9558 9365 Mobile 0403 055 338 Email [EMAIL PROTECTED] Web www.watech.com.au --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10516 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10518