The MapInfo Manual describes how to do outer joins via a 2 step process ; 1. Run your normal Join query then save this query as a new table using Save Copy As 2. Open the table and select all records from table B that are not in the new table. Append this query to the new table.
Something like this Select * from TableA,TableB where TableA.Col1 = TableB.Col1 into MyQuery Save MyQuery as NewTab Open Table NewTab Select * from TableB where not Col1 in (select Col1 from NewTab) into AnotherQuery Then Append AnotherQuery to NewTab Still not a proper query because you have to create a new table Steve McArthur GIS Manager Warren King & Company 2 Victoria St Midland Tel : (08) 9274 2535 Fax: (08) 9274 2545 Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Robert Crossley" <[EMAIL PROTECTED]> To: "Jeff Grice" <[EMAIL PROTECTED]> Cc: "MapInfo List" <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 5:47 AM Subject: Re: MI-L MI: Outer Join in MapInfo v7 > The only way I know how to do an outer join is by using the table > update column. The table to update being the left side of the join, and the right > side the table to get the data from. Make suer you make the column to update "add a temporary column". > > All records from the left side will be included in the result, but you will not get mulitple records where there is a one to many relationship. You can > also only get one column at a time. > > Works for some instances. > > R > > Robert Crossley > Neo Software > 9 Short St > New Brighton 2483 > Far Southern Queensland > AUSTRALIA > > P: 02 6680 1309 > F: New Connection > M: 0419 718 642 > E: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 5251 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5254
