Hi Jeff

Firstly no I never even heard of ACN.

Second you are right I might be trying to get data from across multiple years in that case I would condition...

Thank you so much guys for the quick reponce you are awesome.

The tables I mentioned in my post are not actuals its just an example to get an understading of...

Hugo,

Many thanks, that was the only query that worked for me 🙂 Awesome!!!

Thanks a lot

THanks Igor I will try it out, I just noticed I am using Left Join, not sure if that was the issue.

Thank you very much

THanks Igor,

I did use join, the problem is I get multiple records of the same CustID since there are 2 records in Table2 of CustID (116), as soon as...

Thanks for the reply.

Basically I'm searching for all records in Table1 where the LangName = 'English', I only need to result set from table1.

However because the same record in Table1...