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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2010-11-05 : 15:35:24
|
| Hi:I am pulling from an Open query using an Oracle database. I am trying to remove all EX-Employee and All Retiree from the Table. I am having problems filtering out using the following query: --------------------------- JOIN hr_locations hl ON pax.location_id = hl.location_id JOIN per_people_x sup ON pax.supervisor_id = sup.person_id WHERE pax.primary_flag =''Y'' and ppt.user_person_type <> ''Ex-employee'' and ppt.user_person_type <> '' Retiree''') AS derivedtbl_1Thanks for the Help!!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-11-05 : 15:48:55
|
| Thank you, I think I have found a solution. Thank you all |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
I am having problems filtering