Way to much in one question
Select distinct colTxt from myfile
This requires that the entire returned row (all the columns selected) are unique
SELECT distinct [5000ChyPhantoms].Application, [5000ChyPhantoms].OE1, [5000ChyPhantoms].PN, [IN0140 79 wOE].PN, [IN0140 79 wOE].ComprsOE
FROM 5000ChyPhantoms LEFT JOIN [IN0140 79 wOE] ON [5000ChyPhantoms].PN = [IN0140 79 wOE].PN;
This would eliminate duplicate rows where all 5 fields matched the 5 fields of another row.
We appreciate the feedback.
A lot of this comes with time.
Here’s a discussion of learning resources including some SQL resources