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
 Old Forums
 CLOSED - General SQL Server
 compare string in table

Author  Topic 

iffi
Starting Member

3 Posts

Posted - 2005-12-06 : 09:34:47
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:37:45
Post some sample data and the result you want

Madhivanan

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

X002548
Not Just a Number

15586 Posts

Posted - 2005-12-06 : 09:38:34
Is this homework?

Read the hint link in my sig to see how to post a question



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page
   

- Advertisement -