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

    need to make this work and be db independent

    I have this clumsy solution, so at least it is working. Need to see if I can refine it :-) Thanks for all your posts. I was not being specific about version because I need it to run on a few versions other than 9i. Select PEOPLE.name, CONTACTS.address, Count( distinct...
  2. jangleejat

    need to make this work and be db independent

    DB2 and Oracle would be good enough
  3. jangleejat

    need to make this work and be db independent

    Thanks for your posts - I have to do it in one query which will work on any database.
  4. jangleejat

    need to make this work and be db independent

    In the following query I only get rows returned when a person has friends. I also want to get names and addresses for people who have no friends with a 0 in the result for friends. Problem is that it has to be db independent. If anyone can solve it, please also put in explanation for the...

Part and Inventory Search

Back
Top