compare one record to a minimum of a group of records

M

Michelle W.

I have one record in table A. I have a group of records in table B. I need to
know if one of the columns in table A is less than the minimum of the group
of records in table B (for a particular column in table B). How would I do
this?
 
M

MGFoster

Michelle said:
I have one record in table A. I have a group of records in table B. I need to
know if one of the columns in table A is less than the minimum of the group
of records in table B (for a particular column in table B). How would I do
this?
Click to expand...

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

Perhaps:

SELECT col_A As MinA
FROM tableA
WHERE col_A < (SELECT MIN(col_B) FROM tableB)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

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

iQA/AwUBSUcGzIechKqOuFEgEQJwvACeJxfHIuTT9EC3dC0AVbNHslUPEJAAoIAX
ygfq2JsrSKeV2KZAPpGlxnxD
=M8ns
-----END PGP SIGNATURE-----
 
Top