Page History
...
8. Navigate to the SQL Pane and you can see that a complete SQL statement based on your criteria is automatically generated. You should see a SELECT statement that takes into account each of the items you dragged into place. You cannot type in this area. The SQL statement in the SQL Pane should resemble:
No Format |
---|
select
"EMPLOYEE"."EMPNO",
"EMPLOYEE"."FIRSTNME",
"EMPLOYEE"."LASTNAME"
from
"ADMIN"."EMPLOYEE" "EMPLOYEE"
inner join "ADMIN"."PROJECT" "PROJECT"
on "EMPLOYEE"."EMPNO" = "PROJECT"."RESPEMP"
where
("EMPLOYEE"."HIREDATE" > '1/1/2003') AND
("EMPLOYEE"."JOB" = 'MANAGER') |
Press [Ctrl + E] ([Cmd + E] on OS X) or click on the [Execute button] in the Query Builder Toolbar to view the result of the generated SQL Query.
...