Jump to content

Join tables


vj5

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...