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 |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2013-05-13 : 09:13:21
|
| Good morning all.The following query isn't working for me in Crystal Reports. It's the "WHERE Location IN (30,31,32) part that I'm trying to get to work. I get an error saying that "Too few parameters, expected 3". Is there another way to get this effect? If so can you please show me how it's done? I know this is not a CR forum but I'm just looking for SQL Syntax help. Anyone can help me with this? Please.SELECT OEINVH.`CUSTOMER`, OEINVH.`BILNAME`, OEINVH.`TERRITORY`, OEINVH.`INVFISCYR`, OEINVH.`INVFISCPER`, OEINVH.`INVNETWTX`FROM `OEINVH` OEINVH WHERE OEINVH.`LOCATION` IN (`30`,`31`,`32`) ORDER BY OEINVH.`TERRITORY` ASC |
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2013-05-13 : 10:53:11
|
| Never mind, figured it out. Thanks, anyway :) |
 |
|
|
|
|
|
SQL Syntax