First of all, since there is no matching columns between Table P and Q, your join will result in a table will all 6 columns: x, y, z, a, b, c. This implicit outer join is equal to concatenate.
Regardless, you may specify the where condition as follow
LOAD a, b, c
WHERE a='condition A'
LOAD x, y, z
WHERE x='condition X'