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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 matching and extract result

Author  Topic 

iffi
Starting Member

3 Posts

Posted - 2005-12-06 : 09:35:51
hi i have to compare a some fileds. table name is subject oldsub, newsub on the basis of oldsub student get exemption in new subject. ones student selects one old subject the result show the exemption to new sub.

problem is that by selecting 2 old subject one new subject is exempted so pls tell how to control this the table structure is

sno
oldsub
newsub

thanks in advance

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-06 : 09:48:49
Duplicate post
http://sqlteam.com/forums/topic.asp?TOPIC_ID=58658

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -