hello every one, i am in the process of converting my database from access to mysql ... now tat i have started working with mysql i have realized that my subqueries wont work here ... i read the article on how to handle some of the simple subqueries with joins ... my subquery is as follow and i dont think i couldnt really convert it ...
Select Payment_Date from payments where Payment_Id in (select max(Payment_id) from payments where Payment_Claim_Id=#Claim_Id#) wat option do i have other than using 2 queries ... Also i am doing my developement using mysql 4.0 version ... i see that 4.1 is in its alpha does anyone have an idea when it be ready to use for production ... (if it could be used for production then ... i dont have to do the painfull conversions ) Sandeep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
