You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of ...

@datune I might be wrong, but I'm pretty confident that subqueries are intentionally limited to not include scopes (besides, perhaps, global scopes) because it becomes difficult for the query builder ...

Can MS Access only return 1 record with a SubQuery?? Or, is this a general rule that applies to SQL?

Layer-1 Tradfi and DeFi platform Algorand obtained access to SubQuery's data indexing capabilities. This was made known via a recent announcement. It follows from other such achievements- Cosmos, ...