lets say i have two tables:
module --------- VARCHAR module_name INTEGER module_id module_config ---------------- INTEGER module_id VARCHAR config_name VARCHAR config_value config item names and values are rather arbitrary and depend on the module. each module can have zero to many config items.. How do i find out the id of a module with the following two module_config entries: config_name='mapping' and config_value='true' and config_name='loc_enabled' and config_value='true' it seems like i would have to use a subquery to check two rows at the same time. I wasn't really sure how to express it in SQL though. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
