Select Query Question

[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

 

[Allen Browne]

Use EXISTS or IN in the main query.

 

[sturner333]

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

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.

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

 

[Allen Browne]

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.

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

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.

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