Recent content by VDJ
-
V
Selection on price, stock and delivery time in one query
This table is daily generated with new data from our suppliers. Johan -
V
Selection on price, stock and delivery time in one query
Hello, I have a table with following structure : Fabcode Price Stock Date Supplier Fabcode : the unique code of the article Price : the price by this supplier Stock : quantities for the moment in stock by this supplier Date : When there is no stock at this supplier, the estimated time of... -
V
Query group by and display other columns
Thank you very much, it works from the first time ! I appreciate your help very much. Johan. -
V
Query group by and display other columns
Hi all, I have a table with 4 columns : Product Price Quantity Supplier Product1 5 240 A Product1 7 19 B Product1 6 12 C Product2 96 0 A Product2 98 23 B Product2 99 44 C There are 3 suppliers for the products (name of the suppliers are A, B and C). I...