Combine two tables to create a table or view showing which coords are inside which polygons

[yosiasz]

Check this ild thread

Joining tables using LAT/LONG

I have a transaction table with LAT/LONG variable. I do like to match this with ABS boundary table (ie ASGS_2016_SA3_Points) to bring the SA3 Code and Boundary name. Do any one have a some code to match two tables using lat/long variable. Any help on this will be highly appreciated. Kind Regards Jay