Parameter input through a subquery

dsmbwoy · #1 (**permalink**) 04-05-07, 16:23

Can someone please help me out. I am trying to create a Microsoft SQL query for an excel report that gets its parameter through a subquery. I keep getting the following error however 'Parameters not allowed in queries that can't be displayed graphically.'

Below is my SQL query that has been simplified. Can someone please show me what I am doing wrong.

select * from report where column_A is in
(select column_A from
from report
where (column_B = ?) and (column_C = 1))

Thanks

r937 · #2 (**permalink**) 04-05-07, 17:02

try this --

Code:

select distinct foo.* 
  from report as foo
inner
  join report as bar
    on bar.column_A = foo.column_A 
   and bar.column_B = ?
   and bar.column_C = 1

dsmbwoy · #3 (**permalink**) 04-09-07, 02:30

Thanks for the try but I still get the same error 'Parameters not allowed in queries that can't be displayed graphically.'

stolze · #4 (**permalink**) 04-10-07, 15:18

The query above is regular SQL and works fine on standard-compliant systems. So you may want to ask your question in a SQL Server specific group - not in a group for SQL questions.

r937 · #5 (**permalink**) 04-10-07, 15:22

change the first AND to WHERE and try it again

aschk · #6 (**permalink**) 04-11-07, 04:55

Looking at your original post I would say it looks like you are trying to do a select of a select (which is possible in MySQL, however i'm not so sure for MSSQL).
My solution would be :

Code:

SELECT * FROM
  (
   SELECT column_A
   FROM report
   WHERE (column_B = ?) 
   AND (column_C = 1)
  )

However I would say what's the different between that and this :

Code:

SELECT column_A
FROM report
WHERE (column_B = ?) 
AND (column_C = 1)

I think i'm missing something here, because it looks to me like you're getting the same data twice just by joining the table to itself on column_A???

Internet Services

Web Development

Digital Marketing

Consumer Tech