SELECT [Table1].NAME, [CopyTable1].NAME
FROM [Table1], [CopyTable1] AS [Copy]
GROUP BY [Table1].CUSTOMERNAME, [Copy].CUSTOMERNAME;
This gives me two columns, however the length of the rows in the query becomes however many entries there are squared, meaning that a large table would become very...