Inner Joining three tables
select *
from
tableA a
inner join
tableB b
on a.common = b.common
inner join
TableC c
on b.common = c.common
You can join like this also
SELECT * FROM TableA A,TableB B,TableC C
WHERE A.Column=B.Column
AND A.Column=B.Column
AND A.Column=C.Column
No comments:
Post a Comment