Perry when you join more than one table, fields that have common names must be qualified meaning the field must have customer. or tp. I think 'ass_sclass' needs to be qualified.