I should add that the table AWGCustom.dbo.COMS_PAYTABLE has more fields that I am using in this query. I just dont need them now so I skip them.