Posted by Justin Reynolds on April 26, 2006 at 08:48:34:
Hopefully a quick question -
If the same field exists in multiple tables, is there an order of precedence as to which one is printed when using "USING" statements?
Example:
'MAIN_TABLE' with fields, "thing" and "wokka"
'2ND_TABLE' with fields, "thing" and "foo"
'3RD_TABLE' with fields, "thing" and "foo" and "bar"
INPUT 'MAIN_TABLE'
SELECT blah blah blah
USING 'MAIN_TABLE -> 2ND_TABLE'
USING 'MAIN_TABLE -> 3RD_TABLE'
PRINT THING; WOKKA; FOO; BAR
..so, which "foo" gets printed? From tests, it doesn't look like the order of the USING statements matters..
Maybe more importantly: can I do something like, "PRINT 3RD_TABLE.FOO"?