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.id, pt.first_nm, pt.addr,
et1.emp_id, et1.emp_pay, et1.emp_name
FROM personnel_table pt, emp_table_1 et1
where pt.id = et1.emp_id
and et1.emp_pay >
( SELECT emp_id -- typo here?
from emp_table_1
where emp_id = '3764'

Options: ReplyQuote


Subject
Written By
Posted
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.