Tables Joining

Question

How to join the 3 tables with respective columns into display one table.

Answer 1

Hi,

try something like this

SELECT a.*, b.*, c.*
FROM Tabl1 AS a JOIN Table2 AS b
ON a.col1 = b.col1
JOIN Table3 AS c
ON b.col1 = c.col1
/*
and you can specify column name in select
SELECT a.col1, a.col2, a.col3, b.col2, c.col4
FROM Tabl1 AS a JOIN Table2 AS b
ON a.col1 = b.col1
JOIN Table3 AS c
ON b.col1 = c.col1
*/

More about JOIN

I hope this is helpful.

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com