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