SQLTeam.com | Weblogs | Forums

Write a SQL statement to make a join on the tables salesman, customer and orders in such a form that the same column of each table will appear once and only the relational rows will come?

i dont know query plz provide me

select 
   a.column_same 
from 
   salesman  a
      join 
   customer b 
           on a.column_same = b.column_same 
     join 
    orders  c 
           on a.column_same = c.column_same