Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2009-03-27 : 05:23:43
|
| Sir we have 3 table's1.) tbl_employee :- Colums are empid , empname , deptid2.) tbl_Dept :- columns are deptid , deptname3.) Dept_head deptid , empidNow we find data like this Empname , Deptname , DeptheadnamePls help me out sir Yaman |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-03-27 : 05:27:22
|
Use INNER JOIN to connect tables to each other.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Need Query