use the join on the tables.
String s = "select * from (tableA , tableB) on tableA.z = tableB.x"

mysql join reference