[absconder]

bunu dener misiniz?

SELECT k1.*, k2.* 
FROM UyeKayitlar k1, UyeKisisel k2
WHERE k1.UyelikTuru=4  
	AND k1.UyeId = k2.UyeId 
	AND k1.strTarih = (SELECT MAX(strTarih) 
			FROM UyeKayitlar k3 
			WHERE k1.UyeId = k3.UyeId) 
ORDER BY k1.UyeId DESC