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

    GROUP BY ID in query where there are null values for ID

    tried it.same results. records with null groupids are grouped together. someone advised to use UNION: SELECT * FROM table WHERE groupID IS NOT NULL GROUP BY groupID UNION SELECT * FROM table WHERE groupID IS NULL works but only for mysql versions 4.x.x our server has mysql v3.x.x. so i...
  2. djhunx

    GROUP BY ID in query where there are null values for ID

    I have a table of items each having a field called groupID. In the table, there are items having the same groupID but most have null groupIDs. I want to be able to do a SELECT query GROUPING the items by groupID and also want to return all items having null groupIDs. What happens is that all...

Part and Inventory Search

Back
Top