Jephe I hope you find an answer, but I came across this problem in an unrelated issue. My solution was to crate a new field in the table by combining (concatenating) the values, and linking on that. Not an elegant solution, but it worked.
Ron -----Original Message----- From: Jephe Nache [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 July 2003 5:18 AM To: [EMAIL PROTECTED] Subject: MI-L Update Column...JOIN question... When using the MB 'Add Column FROM blah WHERE blah=blah' you can only join columns 1 to 1. Is there a way to join 2 columns from each table? eg. ID PHASE VALUES a 1 9.2 a 2 10.4 b 1 7.8 b 2 8.9 Add Column SHAPES(values Float) From Data Set to VALUES Where (COL1 = COL1) AND (COL2 = COL2) The above code does not work, only if I leave out the "AND (COL2 = COL2)" part. ANY IDEAS? respond to [EMAIL PROTECTED] (without the "_" ...trying to avoid spam) many thanks _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7831 ******************************************************************************* Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
