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:
Hi all,
I have two three tables, spread accross two databases:
hotel_1 database:
table room (room_id, room_name)
table package (package_id, package_name)
master database:
table search_cache (date, room_id, package_id, hotel_id)
I'd like to search for any combination of room/package ids that do
