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 - 2005-10-10 : 07:56:32
|
| sanjeeb writes "suppose there are two tables emp and amp1having fields as table empempname empno dessigsanjeeb 111 managerrajeeb 112 engineer ----------------- table emp1empname empno sanjeeb 111 rajeeb 112 rohit 345-------------------now my query is how i'll select q1>get me the rows available in emp and not in emp1q2>get me the rows available in emp1 and not in empq3>get me the columns available in emp but not in emp1q4>get me the columns available in emp1 but not in emp" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-10 : 07:57:51
|
| Suppose you do your homework assignments yourself, instead of trying to get someone else to do them for you.SQL Server Books Online has these answers, you just have to look for them. |
 |
|
|
|
|
|
query problem