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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-11 : 08:18:06
|
| Anandh writes "I have two tables with name empdet and empdep, empdet has empno and empname as two fields, empdep has departmentno and empno as two fields, Empdet---empno empname Empdep-- departno empno 1 scott 1 2 2 xavier 2 3 3 Micheal How to write Sql query to get the result like.. scott xavier xavier micheal" |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-11 : 08:20:57
|
| Select A.EmpNo, EmpName,EmpDep From EnmpDet A inner join EmpDep B on A.EmpNo = B.EmpNoIf Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
About query