vijay.vizzu
Member
Hi.. All 
I tried to write a query which can extract my data from Ms access database
I have two tables namely dbo_users and dbo_SupplierUsers
My question is :
1 ) I need to search SupplierCode in dbo_SupplierUsers, once it found it should return the UserCode (might be more than one user). Till this step, i can do it, but next step i can't.
2) After getting UserCodes, they should match in dbo_Users, once it found it should return EmailPrimary
So could you please help me to write a SQL Query ?
I tried to write a query which can extract my data from Ms access database
I have two tables namely dbo_users and dbo_SupplierUsers
My question is :
1 ) I need to search SupplierCode in dbo_SupplierUsers, once it found it should return the UserCode (might be more than one user). Till this step, i can do it, but next step i can't.
2) After getting UserCodes, they should match in dbo_Users, once it found it should return EmailPrimary
So could you please help me to write a SQL Query ?
