I have a dataset with parcels with a unique lotplan - lets say it has 10,000 records. I have a dataset which has owner info which has one or many owners for each lotplan lets say it has 11,0000 records. For example this would be an apartment complex or similar where there are many owners.
We need to join the parcels to owner by lotplan and where a single lotplan has multiple owners the lot plan spatial object should be repeated in the dataset for each.
So we should end up with a combined dataset of 11,000 records.
How can I do this in Mapbasic?
In QGIS I'd use Virtual Layers (Joining multiple records to single feature using QGIS?)
The brute force method maybe to rebuild the parcel table based on the owner info. So row by row go through the owner table by lotplan, find the spatial record in the parcel dataset, append it to a new table, fill in the fields based on the records in both datasets and then do the next one in the owner table. This will ensure one spatial object for each record in the owner dataset.
I hope I don't have to do the above and there's an easier way...