I would like to create a new table (C) from two tables (A & B). A & B have like primary keys. I have used a SELECT INTO, but only A's data will go in, not B's. Although B's column headers are there, there is no data from B. What am I doing wrong???
SELECT civicno_xyposen.Easting, civicno_xyposen.Northing, civicno_xyposen.Latitude, civicno_xyposen.Longitude INTO QCN_Table
FROM civicno_xyposen INNER JOIN quiscivxref ON civicno_xyposen.maplink = quiscivxref.maplink
ORDER BY civicno_xyposen.maplink, quiscivxref.maplink;