I need to run a JOIN in Mapbasic and retain all records of the first table as well as the matched records.
So
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
Results in all the non-matched records being saved but this results in the unmatched records being dropped.
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?