query Join or criteria

  • Thread starter Thread starter Michael N
  • Start date Start date
M

Michael N

I have a query that pulls all records with a test value
below 40. What I would like to do is pull all records for
a visit if one test durring the vist is below 40. I am
sure this is easy, but I am stupmed at the moment. Can
aynoe give me some direction?

Mike
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not knowing your db design I can only guess:

SELECT *
FROM table_A
WHERE VisitID In ( SELECT VisitID FROM table_A
WHERE test_column < 40 )

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQUnVr4echKqOuFEgEQJZMQCfe+DLLKC/d/pS5qspKbT20XIuvRwAn3hf
KAi/ixPYvEP/F+GfuIMFm6q2
=mvdY
-----END PGP SIGNATURE-----
 
Back
Top