I am looking for an SQL statement that will produce the following affect. I am not sure which aggregate function you need to do this if you can please help I would greatly appreciate it. table1
I have a file with 3500 unique rows of information, we will call this File # 1. I would like to query against a larger table (of 9.5 million rows), we will call this File # 2.