sub queries in mysql?

[Jasper Bijl]

------=_NextPart_000_0075_01C36186.A832CF80
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello,

Is there a way to do something like subqueries in one query?

I have a customer table (Klant) with contacts (KlantKontakt) and a
address (Adres) table.
The address table keeps a record of each different address for a
customer including old addresses (to maintain history).

If I want to retrieve a list of customers with their newest address, I
have to do a max() to retreive the last address.
I can do this in PHP in a seperate query but I like to do it in one
query on the mysql prompt.

Below is my (wrong) query:

SELECT
Klant.klantcode, Klant.naam,
KlantKontakt.persooncode, KlantKontakt.Achternaam,
Adres.straat, Adres.postcode, Adres.plaats

FROM Klant, KlantKontakt, Adres

WHERE SoortKlant = 'Prospect'
AND Klant.klantcode = KlantKontakt.klantcode
AND Adres.klantcode = Klant.klantcode

ORDER BY Klant.Naam
Is there any way to do this in MySQL in one query?
Regards,

Jasper Bijl

------=_NextPart_000_0075_01C36186.A832CF80--