$P{param1}.equals(" ") ? "SELECT * FROM tablerecords" : $P{param2}.equals($P{param1})

SELECT
c.id,
p.lastname,
p.firstname
FROM person_tbl as p,code_tbl as c
WHERE $P!{param2}
AND p.id=c.id
ORDER BY 1;