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 |
|
rnelsch
Starting Member
31 Posts |
 Posted - 2012-03-23 : 12:14:20
|
| is there a way to exclude data in a query without using the INNER JOIN? If I know the field has specific values I want to exclude from the query. Ryan A Nelsch |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-03-23 : 12:19:39
|
| You can use a "NOT IN" or "NOT EXISTS" in the WHERE clause. Don't know what would be best in your scenario without more details. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-23 : 12:19:47
|
specify in WHERE clause ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
rnelsch
Starting Member
31 Posts |
Posted - 2012-03-23 : 12:47:12
|
| The table is CALL and the field is CallType Right now it looks like this:Select Call.JobID, Call.CallType, Call.Department, Call.BookedDate, Call.SchedDate, Call.IsScheduled, LeadSource.LeadSource, Call.DispatchedDateFrom LeadSource, CallWhere Call.SchedDate between '3-1-2012' and '3-31-2012' so could I add/change my WHERE clause to Where Call.SchedDate between '3-1-2012' and '3-31-2012' and Call.CallType <ACSU> (ACSU being the specific value)Ryan A Nelsch |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Exclude Data