-
What kind of a query is this? How does it work?
Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help. select ename,(select dname from dept where deptno=e.deptno) from emp e;
Mark Haynes
- Apr 11th, 2012
Youre using a Sub-query -- [(select dname from dept where deptno = e.deptno)] -- to get around using a join clause like -- [FROM EMP E INNER JOIN DEPT D ON (D.DEPTNO = E.DEPTNO)] -- however, you are n...
Blaster_Ayub_Khan
- Apr 10th, 2012
SQL coins the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database. All SQL queries perform some type of da...
