I would like to have a subquery where I'm comparing 2 values from the
subquery to the main query and unsure on the syntax. I know in Oracle sql
it's something like
WHERE (manager_id , dept_id) IN (SELECT manager_id, dept_id FROM table ...
etc)
Re: Bizarre subquery syntax problem ... With Access, the official syntax for a subquery always requires an alias, so ... SELECT p.AS UID, p.Firstname AS Firstname, p.Lastname AS Lastname, ... I am seeing bizarre problems with a subquery....core query runs fine- ... (microsoft.public.access.queries)
RE: EXISTS reserved word in FROM clause ... we make a good pair because I know Access SQL... from what you described the query syntax that I ... >The subquery should return the records: ... (microsoft.public.access.queries)
Re: syntax error in Total of field - I need help ASAP, PLease ... "check the subquery's syntax and enclose the subquery in parentheses". ... "SELECT Rent, FROM PO 1189-616) as Rent Sum ... you posting the entire SQL (query) statement? ... IF you are trying to use a subquery in the select clause of a query then ... (microsoft.public.access.queries)
Re: Jet SQL and Virtual tables/subqueries qiestions ... errors out of the query builder and/or Jet SQL parser.... doesn't the Access/Jet syntax documentation state that s ... selects the outer query instead of just the inner subquery SQL... (microsoft.public.access.queries)
RE: expression question ... "The syntax of the subquery in this expression is incorrect. ... So I added the parentheses,... but the query does not run. ... (microsoft.public.access.queries)
