Your table examples and description don't give much to go on as the relationship of the tables is not known. I can only guess on the ID columns but I am unsure.
If you are looking at joining the information in the 2 tables on matching information I would start with
inner join[
^].
you can also look up information on outer joins, I would Google on "TSQL left outer join" if you want to show information that is in the left table but not the right table
P.S I have made an assumption that you are looking at SQL Server, If I am wrong please let know and I'll update my answer.