Or field16 = @doctor2 or field16 = @doctor3...?


-----Original Message-----
From: daniel@o... [mailto:daniel@o...]

Sent: Friday, January 10, 2003 7:59 PM
To: sql language
Subject: [sql_language] multiple selects grouped together.


i need some help with running a query 3 times with 5 different
paramaters 
and spitting out the output in one row. for example. i have the query:

SELECT count(field16) AS Expr1
FROM thelist
WHERE (((thelist.Pt2.Field2)>[@Begindate] And (thelist.Pt2.Field2)<
[@endDate]) AND field16 = @doctor);

that acceps 3 inputs (begin date end date and doctor) i need to have
this 
query be run of 5 different doctors and then give me back the results.

i feel like this is clear as mud, but im not quite sure how to do it
best. 

thanks
daniel