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 |
|
Jamalo
Starting Member
6 Posts |
 Posted - 2010-08-06 : 08:29:20
|
| I have a problem with running this queiry but I dont know whats the reason?When I run this quiery i get the following error:"ERROR: operator does not exist: integer = character varyingLINE 5: (COALESCE(t."Order_number") in (select COALESCE("DESCRIPTION") from... ^HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts."The same queiry does work for another table but not for this one?What could be the reason?? Please Help this is the query I am using:SELECT *FROM "TableA" tWhere not(COALESCE(t."Order_number") in (select COALESCE("DESCRIPTION") from "TableB")); |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-06 : 11:09:31
|
I have doubts if this is MS SQL Server.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Getting error when running SQL query, Please HELP