Thank you Peter, The key is writting a single relation without formulas at every logical clause (every AND, OR, etc). Formulas like RIGHT$(field2,3) or "0"+field1 are also forbidden. The solution, as you have said, is splitting the condition. Previously I've updated that field with different length.
Thank you again. Sergi -----Mensaje original----- De: Peter Horsb�ll M�ller [mailto:[EMAIL PROTECTED] Enviado el: lunes, 07 de marzo de 2005 14:14 Para: Gamiz Ribelles, Sergi (Regsa) Asunto: RE: MI-L Joining non natives tables with more than one fields Have you tried splitting the condition: "0"+tab1.field1 = tab2.field1 AND tab1.field2 = tab2.field2 AND tab1.field3 = tab2.field3 But I'm not sure whether you actual can use a expression ("0"+tab1.field1) Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: Gamiz Ribelles, Sergi (Regsa) [mailto:[EMAIL PROTECTED] Sent: Monday, March 07, 2005 2:08 PM To: Mapinfo-list (E-mail) Subject: MI-L Joining non natives tables with more than one fields 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15566
