Jump to content

Join tables


vj5
 Share

Recommended Posts

I have three tables: Emp, Manager and Company

Emp :empidempfnameemplnameempaddrManager:manageridmanagernamemanageraddrCompany:compidcompnamecompaddrempidmanageridSQL Join:Select * from emp, manager, companywhere emp.empid = company.empid and		  manager.managerid = company.compid;

Can someone please let me know if my select statement is right. If it is wrong, can you give the right statement?

Link to comment
Share on other sites

The SQL statement is syntactically valid, if that's what you're asking. That doesn't mean it's going to do what you want to do, but it will run.
What do you mean by that? can you explain in detail? and also can you give some examples on joins.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...