Ok that worked to an extent
if I just run
SELECT pay.* from Payments pay
JOIN motorvehicle mv ON mv.keyident = pay.pkeyident
AND pay.py_modtype = 'MV' AND mv_judge = '1'
I get a record set returned
once I add

JOIN locallaw ll ON ll.keyident = pay.pkeyident
AND pay.py_modtype = 'LL' AND ll_judge = '1'

no records are returned