Update query based on different conditions

Hello:
I have 3 queries and 1 table (ID as primary key). Is there any way that a
update query can deal with 3 conditions and update "Status"?
if a.ID=b.ID, then a.Status="Possible"
if a.ID=c.ID, then a.Status="Probable"
If a.ID=d.ID, then a.Status="Confirmed"
If not, what would be the solution?
Thanks in advance!

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

Looks like 3 UPDATEs are required:

UPDATE a INNER JOIN b ON a.ID = b.ID
SET a.Status = 'Possible'

UPDATE a INNER JOIN c ON a.ID = c.ID
SET a.Status = 'Probable'

UPDATE a INNER JOIN d ON a.ID = d.ID
SET a.Status = 'Confirmed'

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

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

iQA/AwUBQTUBjoechKqOuFEgEQIHsACfT0w9X/mq5Scf+YJRypMMLnKZUP0AniOJ
3hyPXK5iER+xOc0kGjB3jw0w
=MHl9
-----END PGP SIGNATURE-----


Vincdc wrote:

Hello:
I have 3 queries and 1 table (ID as primary key). Is there any way that a
update query can deal with 3 conditions and update "Status"?
if a.ID=b.ID, then a.Status="Possible"
if a.ID=c.ID, then a.Status="Probable"
If a.ID=d.ID, then a.Status="Confirmed"
If not, what would be the solution?
Thanks in advance!