Select only one row in 2nd table that matches

[DeZiner]

I loop thru the records in table one, column1 & column2. I check for an identical match of the same in table 2. If table 2 has three identical records it matches all. How can I get just a one on one match. This way if table one has an identical row later, it can match one of the other two in table2 DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[CFDude]

You can try DISTINCT e.g

Select DISTINCT somefields from Table2
Where etc...

HTH,
Tim P.