Then he told me to write a query. He wanted me to retrieve data from two tables. The main thing was that we should use " group by "any questions?

Questions by mithila

Showing Answers 1 - 6 of 6 Answers

pradipto_dg

  • Aug 26th, 2007
 

To retrieve data from two tables its not always needed to use order by clause.
e.g:-
select first_name,last_name,department_id
from employees,departments
where employees.department_id=departments.department_id;

just use joins

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions