TSQL error

I have 2 tsql queries but they contain some error. can anyone find that error.

SELECT * FROM job
JOIN ship ON job.job_id = ship.job_id
JOIN recipient ON ship.airbill = recipient.airbill
WHERE
job.job_id = 112 AND
ship.airbill = '11222333' AND
recipient.email = 'asdf@asdf.com'

**********************************************************
SELECT p1.user,
p1.value 'email',
p2.value 'billing_type',
p3.value 'billing_id_1',
p4.value 'billing_id_2',
p5.value 'office_id'
FROM pss_pref p1
JOIN pss_pref p2 ON p1.user = p2.user AND p2.field = 'billing_type'
JOIN pss_pref p3 ON p1.user = p3.user AND p3.field = 'billing_id_1'
JOIN pss_pref p4 ON p1.user = p4.user AND p4.field = 'billing_id_2'
JOIN pss_pref p5 ON p1.user = p5.user AND p5.field = 'office_id'
WHERE
p1.user = 'remery' AND p1.field = 'email'