-
May 13th, 2013, 08:08 AM
#1
[RESOLVED] SQL Help
Good morning all,
When I run my report I get an error message that says "Too few parameters, expected 3". It's the "Location in (30, 31, 32)" that I'm trying to get to work in the query and it's not happening. I've tried it with and without quotes on the 30, 31, 32. Can someone please tell me what I'm doing wrong or show me another way to get this to work. 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
-
May 13th, 2013, 09:51 AM
#2
Re: SQL Help
Never mind; figured it out. Thanks anyway
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|