It will be as the below query, but replace: distinct p.* with: count(p.ID) RBS
>> Allan, Mark wrote: >> > What I want is Joe Blogs just the once. >> > >> > >> Mark, >> >> Then try adding distinct like this: >> >> select distinct p.* >> from PatientsTable as p >> join ExaminationsTable as e on e.PatientID=p.ID >> join TestTable as t on t.ExamID=e.ID >> join ForcedSpiroTable as f on f.TestID=t.ID >> join RelaxedSpiroTable as r on r.TestID=t.ID >> where f.EVC > 2.0 and r.FVC > 2.0; > > Ok, so here's another question, how would I get the count of patients > where the EVC and FVC > 2.0? > > > > DISCLAIMER: > This information and any attachments contained in this email message is > intended only for the use of the individual or entity to which it is > addressed and may contain information that is privileged, confidential, > and exempt from disclosure under applicable law. If the reader of this > message is not the intended recipient, or the employee or agent > responsible for delivering the message to the intended recipient, you are > hereby notified that any dissemination, distribution, forwarding, or > copying of this communication is strictly prohibited. If you have > received this communication in error, please notify the sender immediately > by return email, and delete the original message immediately. > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------