Untitled

How to perform same query on two different tables in one query
SELECT `id`
FROM (`videos`)
WHERE  `name`  LIKE '%Dragon Ball Z (U.S.)%'

SELECT `vid_id` as id
FROM (`other_names`)
WHERE  `name`  LIKE '%Dragon Ball Z (U.S.)%'
GROUP BY `vid_id`

SELECT `id`
FROM (`videos`)
WHERE  `name`  LIKE '%Dragon Ball Z (U.S.)%'
UNION
SELECT `vid_id` as id
FROM (`other_names`)
WHERE  `name`  LIKE '%Dragon Ball Z (U.S.)%'