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



Reply via email to