Search results for query: *

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

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