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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aarnone

    A question about joining and group by clause

    Any chance you can give me an example of that?
  2. aarnone

    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.
  3. aarnone

    A question about joining and group by clause

    i am running this against oracle 9i, could this be why it's throwing the eror.
  4. aarnone

    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.
  5. aarnone

    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...

Part and Inventory Search

Back
Top