MySQL Forums
Forum List  »  Newbie

ami ki kortam bujhi na bujina
Posted by: registration rezanurbt
Date: March 19, 2014 06:33AM

Maybe pretty-printing it will help see the issue

SELECT, pt.first_nm, pt.addr,
et1.emp_id, et1.emp_pay, et1.emp_name
FROM personnel_table pt, emp_table_1 et1
where = et1.emp_id
and et1.emp_pay >
( SELECT emp_id -- typo here?
from emp_table_1
where emp_id = '3764'

Options: ReplyQuote

Written By
ami ki kortam bujhi na bujina
March 19, 2014 06:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.