RE: subquery accross different database

2005-09-18 Thread Badai Aqrandista
solved it... i used 'distinct' in main and subquery and somehow it affects the whole query results... --- Badai Aqrandista Cheepy (?) From: "Badai Aqrandista" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: subquery accross different database Date:

subquery accross different database

2005-09-18 Thread Badai Aqrandista
oblem? Is it because the subquery uses other database's table? Thanks... --- Badai Aqrandista Cheepy (?) _ Sell your car for $9 on carpoint.com.au http://www.carpoint.com.au/sellyourcar -- MySQL General Mailing Lis