I need to run a JOIN in Mapbasic and retain all records of the first table as well as the matched records.
Select Cadastral_data_QLD_CADASTRE_DC.LOTPLAN , Austpost_Extract_08_01.Unit_Type , Austpost_Extract_08_01.Unit , Austpost_Extract_08_01.Unit_End_Alpha , Austpost_Extract_08_01.House_Number , Austpost_Extract_08_01.House_Alpha , Austpost_Extract_08_01.House_End_Number , Austpost_Extract_08_01.House_End_Alpha , Austpost_Extract_08_01.Street_Name , Austpost_Extract_08_01.Street_Type from Cadastral_data_QLD_CADASTRE_DC, Austpost_Extract_08_01 where Cadastral_data_QLD_CADASTRE_DC.LOTPLAN = Austpost_Extract_08_01.LotPlan into RAW_DCDB_AusPOST_MATCHED Commit Table RAW_DCDB_AusPOST_MATCHED As "G:\Projects\2016\22_DSC_DCDB_Update\Working\Working_MixedProcess\RAW_DCDB_AusPOST_MATCHED.TAB" TYPE NATIVE Charset "WindowsLatin1" Interactive
In mapinfo desktop I can do an inverse selection and then join the result to the RAW_DCDB_AusPOST_MATCHED.TAB
but I can't do an inverse in mapbasic
I can't do a != in the select either as I need just the records that don't match at all...and I need the attributes of the records where lotplan matches.
What can be done in mapbasic to get all records like in a QGIS/ArcMap join?