Try this one this is the syntax.... SELECT EMPID, ENAME FROM EMPLOYEE I

we have two tables first one is EMPLOYEE
having EmpID, EmpNAME,
Second table is SALARY table
having id, salary
Write a query to get name of those person who having more
than 10000$ salary

Question Posted / shahbaz

3 Answers
6775 Views
Net Solution, I also Faced
E-Mail Answers

Answer Posted / shahbaz

Try this one
this is the syntax....

SELECT EMPID, ENAME FROM EMPLOYEE INNER JOIN SALARY ON EMPID=ID AND SAL>600;

by kibria and shahbaz

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of post in php?

985

Explain the difference between require() and require_once()?

972

What is self in php?

1154

What is constructor and destructor?

975

Explain the difference between $message and $$message?

998

Why session is required?

946

What is empty php?

981

How do you define a constant?

972

Explain me what is the use of header() function in php?

1037

Explain some of the php string functions?

978

What is difference between include and include_once in php?

947

What is the use of php and mysql?

1028

What is regular expression in javascript?

925

Tell us how to create an array of a group of items inside an html form?

978

How can we submit from without a submit button?

1010