Select Query Question

  • Thread starter Thread starter sturner333
  • Start date Start date
S

sturner333

Why would I get a statement for the sql criteria in a query that reads "At
most one record can be returner from this subquery"

SQL:
(select [tblPlatformCategories].[platformid] from [tblPlatformCategories]
where [tblPlatformCategories].[platformid] <> [qry1].[platformid])

I just want to filter out the records from tblPlatformCategories that have
the same platfronId as qry1.
Thanks
 
I don't know what you mean by main query and what part of it would I use
Exists or IN?
Thanks

Allen Browne said:
Use EXISTS or IN in the main query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

sturner333 said:
Why would I get a statement for the sql criteria in a query that reads "At
most one record can be returner from this subquery"

SQL:
(select [tblPlatformCategories].[platformid] from
[tblPlatformCategories]
where [tblPlatformCategories].[platformid] <> [qry1].[platformid])

I just want to filter out the records from tblPlatformCategories that have
the same platfronId as qry1.
Thanks
Click to expand...
Click to expand...
 
The query that you posted: is it *part* of another query?

If not, try removing the brackets around it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

sturner333 said:
I don't know what you mean by main query and what part of it would I use
Exists or IN?
Thanks

Allen Browne said:
Use EXISTS or IN in the main query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

sturner333 said:
Why would I get a statement for the sql criteria in a query that reads
"At
most one record can be returner from this subquery"

SQL:
(select [tblPlatformCategories].[platformid] from
[tblPlatformCategories]
where [tblPlatformCategories].[platformid] <> [qry1].[platformid])

I just want to filter out the records from tblPlatformCategories that
have
the same platfronId as qry1.
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top