I am having trouble creating an sql server query that uses a sub query.
I have a sub query :
SELECT TblWordTags.ClientCode, TblWordTags.ClientCodeWordPosition
GROUP BY TblWordTags.ClientCode, TblWordTags.ClientCodeWordPosition;
The main query (ive restricted it with the where for the moment)
SELECT TblWords.ClientCodeWordPosition, TblWords.ClientCode, TblWords.Word, QrySubQuery.ClientCode, TblWords.StrFull
FROM TblWords LEFT JOIN QrySubQuery ON (TblWords.ClientCodeWordPosition = QrySubQuery.ClientCodeWordPosition) AND (TblWords.ClientCode = QrySubQuery.ClientCode)
Not sure how to port this over to sql server with the sub query despite reading one of the experts posts on access to sql server