joins

[rajmani]

Hi all, I want join in 5tables in my sqlserver database. How I join 5tables,empno is a primary key for all tables. thanks

[amraouf]

select * from tab1 inner join tab2 on tab1.empno=tab2.empno inner join tab3 on tab2.empno=tab3.empno inner join tab4 on tab3.empno=tab4.empno inner join tab5 on tab4.empno=tab5.empno where 1=1

[rajmani]

hi amraouf Thanks for your reply,