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 Chriss 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: *

  • Users: moernoo
  • Content: Threads
  • Order by date
  1. moernoo

    GROUP BY

    Hi, I have the following tables: Tabel 1: "Parts:" PartID | PartCost ------------------ 1 | 0.5 2 | 0.3 Tabel 2: "ConsumedParts" PartID | Quantity ------------------ 1 | 1 1 | 2 2 | 1 Now, i would like to become a table like underneath...
  2. moernoo

    combining multiple records to 1

    Hey, I have the following problem: (in fact it's a bit more complicated but i've tried to simplify it in this example) i've a table with users that gives every user an unique ID. i want to give each user multiple properties. i want these properties chosen from another table. this is the...

Part and Inventory Search

Back
Top