I have a query just for demonstration, I need to create a query that tells me where strshort matches but the client is different its all in one table so I am not sure how to create that.
My feeble attempt after looking at microsoft site
SELECT StrShort1.StrShort, StrShort2.ClientNameFROM TblWords.strshort AS StrShort1 JOIN TblWords.strshort AS StrShort2 ON (StrShort1.strshort = StrShort2.strshort)WHERE StrShort1.clientName <>StrShort1.clientName;