MySQL Federated query two tables of data

MySQL Federated query 2 tables of data
There are 2 tables tb_a tb_b (2 table relationship is A.id=b.tid) how to implement the data of the page with a SQL statement to find out the college and the college teachers in the table field is to write their own random
Page first accept the ID of a college and then query: Ask for a SQL to find out the data needed for the page

------Solution--------------------
SELECT * from Tb_a A, Tb_b b where a.id=b.tid
------Solution--------------------
What do you mean by tb_a,tb_b? Landlord did not say clearly
------Solution--------------------
The second floor is the solution ah.
------Solution--------------------
Big table? Small, you can use the table, big words, first draw a table, in their own implementation of the logical extraction of the second

