Using Subquery for Criteria

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

Is it possible to use a subquery to pass multiple values to a criteria
statement in another query?
 
Possibly. An example.

SELECT *
FROM TableA
WHERE TableA.CustomerName IN
(SELECT FullName
FROM TableB
WHERE FullName Like 'Joh*'
GROUP BY FullName
HAVING Count(FullName) > 1)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Calculated Field 2
Subquery 1
Referring to fields in a subquery 1
Variable subquery criteria SQL problems 1
REPOST: Subquery? 2
Select Subquery: To only display one year at a time 11
Delete sub query problems 4
Query and subquery 2

Back
Top