SQL Command question in apex oracle

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Command question in apex oracle

Author

Topic

LKP
Starting Member

2 Posts

Posted - 2013-12-10 : 00:57:52

SELECT Make, Model
FROM CAR
WHERE EMPID = SELECT EMPID
FROM EMPLOYEE
WHERE DEPTID = SELECT DEPTID
FROM DEPARTMENT
WHERE DEPTNAME = 'COMPUTING';

ORA-00936: missing expression
I can't get the makes & models of cars belonging to employees in the computing department, any help?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-10 : 05:42:00

This is MS SQL Server forum. You may be better off posting it in some oracle related forums for Oracle specific help
having said that my best bet is this


SELECT c.Make, c.Model
FROM CAR c
JOIN EMPLOYEE e
ON e.EMPID = c.EMPID
JOIN DEPARTMENT d
ON d.DEPTID = e.DEPTID
WHERE d.DEPTNAME = 'COMPUTING';

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

LKP
Starting Member

2 Posts

Posted - 2013-12-10 : 08:07:31

Sorry, I thought it is related to SQL, but anyway thx for ur reply :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources