(SELECT
 valor AS the_data_type,
 type AS the_data_id
 FROM TABLE1 WHERE type = 12)

 UNION

 (SELECT
 data1 AS the_data_type,
 data2 AS the_data_id
 FROM TABLE2 WHERE data1 = 5)

 ORDER BY the_data_type