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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

    JOIN / Not existing records as blank cells in the results

    hi I have data in two tables. NAMES ID Name 1 FIRST 2 SECOND ... CODES ID CodeType Code 1 A xyz 1 B abc 1 C gfd 2 A xdz 2 B dca 3 A xvz ... I want to join the two tables to get the records from NAMES with the Code of CodeType "C". if there is no record with the...
    • Mikka07
    • Thread
    • Replies: 2
    • Forum: SQL
  2. Mikka07

    COMPLEX JOINS

    Hi all I have a problem with a complex query. there is one price a day from every suplier in the table Prices. PRICES Product ID | Date | Suplier |Price 0001 | 01.01.2007 | SuplierA | 10 0001 | 01.01.2007 | SuplierB | 11 0001 | 01.01.2007 | SuplierC | 13 0001 | 02.01.2007 | SuplierA | 11...
    • Mikka07
    • Thread
    • Replies: 2
    • Forum: SQL

Part and Inventory Search

Back
Top