Hi list, I want to get joining two non MI tables (the first one looks at a SHP file and the second one looks at a MDB with live acces). I need to join with the where clause: "0"+tab1.field1+tab1.field2+tab1.field3 = tab2.field1+tab2.field2+tab2.field3. (all fields are characters). The syntax button sais it is right. SQLquery dialog returns "No Join spicified betwen tables tab1 and tab2. Invalid join condition in WHERE clause" Is there anyone can explain it to me? Must I make the join by copying both tables to a MI native tables and build in both "joined fields" before? Thank you in advance to all.
Sergi --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15561
