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 - 2000-10-18 : 23:53:21
|
Frances writes "Hi there! Is there a way to have multiple fields in the "NOT IN" clause of a "WHERE" with "SELECT" in SQL7? i.e. WHERE (SEC_Type="3") and (SEC.sec_Cusip, SEC.Date_Stamp NOT IN (Select SecCusip, Date_Stamp FROM Muni_Bonds)) ... Something like this? I just want to be certain I am not violating a Primary constaraint when I insert data. This violation causes the stored proc to abort if executed from Visual Basic 6 (at least for me!)
Thanks bunches!!!
-- Frances" |
|
|
|
|
|
Multiple fields in a