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
