Цена продажи в зависимости от цены конкурента
Ваш SQL-запрос экспорта будет выглядеть так (колонка product_pricesell):
Код
select
product_sku,
product_name,
case when product_price1*0.95 > product_price2 then product_price1*0.95 else product_price2-100 end as product_pricesell,
product_price1,
product_price2
FROM
(
SELECT
G_SID as "product_sku",
G_NAME as "product_name",
price as "product_price1",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 7 AND G_PRESENT = 1) as "product_price2"
FROM TBL_GOODS
WHERE G_ACTIVE = 1
AND G_PRESENT = 1
) t
|