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

    SQL to return if a single row(can be>1) and certain criteria

    Not sure how to approach this as I keep going in circles. I want to return ID's that soley have keyword='ISV' and no other keyword. I tried some count(*)=1 and 'GROUP BY' but it does not seem to work. Example Table id keyword == ======= A ISV A Reseller A Foo B ISV C...

Part and Inventory Search

Back
Top