If you want to get result based on 3 tables then use
Joins[
^]
If you want to combine the 3 select statement result into single, then you must remember one thing fields should be equal, if you want to know more about this refer below link
Union[
^]