I have two tables A & B.
id | name | num
id | date | roll
id in table B is a foreign key which relates to the
id in table A.
I want to get the contents of table B where id is given and also along with that data, I need the name whose id is given from table A.
NOTE: cannot use multiple queries separated by commas; need to do both the
SELECTs in one query.