Bug #69536 nested queries
Submitted: 21 Jun 2013 5:34 Modified: 21 Jun 2013 5:39
Reporter: Jaya Kumar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[21 Jun 2013 5:34] Jaya Kumar 
Description:
I need to generate the report from two tables

How to repeat:
I need the query for getting the records from two tables.
1. First table contains total employees details.
2. Second table contains those employees salary.

condition:
If the employee status is inactive, then the salary table will not show the employee details.

Suggested fix:
I have tried like this:
SELECT * FROM sal_update WHERE mem_no='' AND status='1' and mem_ac_no in (SELECT mem_ac_no FROM `employee_details` WHERE status='1')
[21 Jun 2013 5:39] MySQL Verification Team 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.