Question: I have two tables A & B.

### Table A

```
id | name | num

```

### Table B

```
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 `SELECT`s in one query.

Answer: 
You need to join these tables to get the result that you want.

```
SELECT b.*, a.name FROM tableB AS b INNER JOIN tableA as A ON (b.id=a.id);

```

This query will return everything from Table B and `name` from Table A where the ID from Table B is the same as the ID from Table A.
To retrieve data from both table associated with foreign key i.e(common column)
you have to join both the tables.

if you matching data from both table then use INNER JOIN.

```
> SELECT A.List_Of_columns,B.List_Of_columns  FROM Table1 AS A   INNER
> JOIN Table2 as B   ON A.ID=B.ID (Here Id is Common in both table).

```

If you want matching data from both table along with all records from table1 
then use left join instead of Inner Join. 
if you want all records from table2 use right join.