Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
A question about joining and group by clause
Any chance you can give me an example of that? -
A question about joining and group by clause
even if it does work I need to return the job table records if no log records exist so I need to do an outer join. -
A question about joining and group by clause
i am running this against oracle 9i, could this be why it's throwing the eror. -
A question about joining and group by clause
When I try to run the query above, I am getting an error saying that - a column may not be outer joined to a subquery. -
A question about joining and group by clause
I have this query below which works but I need to modify it so I get a more precise result: Select a1.JOB_SCHED_ID, a1.JOB_SCHED_NAME, a1.JOB_ENABLED_FLAG, a1.JOB_SCHED_TYPE, a1.ONE_TIME_FLAG, a1.ONE_TIME_DATETIME, a1.DAILY_FLAG, a1.DAILY_FROM_TIME, a1.DAILY_TO_TIME...
