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!

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

Recent content by glubschi

  1. glubschi

    How to get the right order in an WHERE xx IN query?

    Many thx Tony. That was exactly the query that I´m looking for.
  2. glubschi

    How to get the right order in an WHERE xx IN query?

    Hi all, I´ve the following problem: 2 tables. The first (table1) has a column id and the second some names. Now I have the second table with a field that has e.g. the following value: "6 3 9" (id=6 id=3 id=9) My query: SELECT id, names from table1 WHERE id IN (6, 3, 9) The result looks like...

Part and Inventory Search

Back
Top