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 Chris Miller 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. paubad

    aggregate combined with nonaggregate

    I ended up finding a workaround by restructuring my solution so I didn't need this select. Sorry to have posted a question that proved unnecessary. If you're curious I can still send you the query that produced the error but this won't be before monday.
  2. paubad

    aggregate combined with nonaggregate

    I tried the above and this resulted in: ORA-00933: SQL command not properly ended
  3. paubad

    aggregate combined with nonaggregate

    I wish to perform a select in which I join two tables. I want to add an extra field telling me for each selected tuple from table 1 - how many tuples from table 2 were joined with it. as follows: table 1: a % b % c + table 2: a 1 a 3 a 5 a 7 b 2 b 3 c 4 c 5 c 6 desired result: a % 1 4 a %...

Part and Inventory Search

Back
Top