SQL help with inner joins.

[DAM]

Can I combine these two statements into one?

FROM (Product INNER JOIN zSysUser ON Product.ER1 = zSysUser.User_ID) INNER JOIN Call ON zSysUser.UserName = Call.AssignTo

FROM (Product INNER JOIN zSysUser_1 ON Product.ER2 = zSysUser_1.User_ID) INNER JOIN Call_1 ON zSysUser_1.UserName = Call_1.AssignTo

I can't figure it out.


Thanks.

dam(sol)

 

[Beau]

If you are getting the same columns, you can use this: