hellovn
10-21-2008, 06:54 PM
Hi All,
I want to simplify this query:
SELECT ENAME, JNAME
FROM E, G, J
WHERE DUR > 12
AND E.ENO = G.ENO
AND ( TITLE = "Elect. Eng." OR G.JNO < "J3" )
AND G.JNO = J.JNO;
There is an "OR" in my query, I don't know how to reduce it.
Thank you very much.
I want to simplify this query:
SELECT ENAME, JNAME
FROM E, G, J
WHERE DUR > 12
AND E.ENO = G.ENO
AND ( TITLE = "Elect. Eng." OR G.JNO < "J3" )
AND G.JNO = J.JNO;
There is an "OR" in my query, I don't know how to reduce it.
Thank you very much.