Question: How to get unique location from three tables, location should be unique in three table?

```
table1 : location = delhi   // location is column name in all three tables <br>
table2 : location = delhi
table3 : location = delhi

```

Result:

```
delhi

```

Answer: 
Try this:

```
select * from table1 INNER JOIN table2 on table1.location = table2.location 
INNER JOIN table3 on table2.location = table3.location;

```
```
SELECT
    location
FROM
    table1
UNION
SELECT
    location
FROM
    table2
UNION
SELECT
    location
FROM
    table3

```

try this