История изменений
Исправление Darth_Revan, (текущая версия) :
SELECT TOVAR_ID, NAME FROM TOVARS_TBL
WHERE FOLDER_ID = (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Мытье')
ORDER BY CODE;
SELECT t1.TOVAR_ID, t1.NAME, t2.NAME AS NAME1
FROM TOVARS_TBL AS t1 LEFT OUTER JOIN TOVAR_UNITS AS t2 ON t1.UNIT_ID = t2.ID
WHERE t1.FOLDER_ID = (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Вывоз')
ORDER BY TOVAR_ID;
SELECT t1.TOVAR_ID, t1.NAME
FROM TOVARS_TBL AS t1 INNER JOIN TOVAR_UNITS AS t2 ON t1.UNIT_ID = t2.ID
WHERE t2.NAME LIKE '%шт%' ORDER BY TOVAR_ID;
UPDATE TOVARS_TBL
SET FOLDER_ID = (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Вывоз')
WHERE FOLDER_ID = (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Мытье');
Исправление Darth_Revan, :
SELECT TOVAR_ID, NAME FROM TOVARS_TBL
WHERE FOLDER_ID IN (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Мытье')
ORDER BY CODE;
SELECT t1.TOVAR_ID, t1.NAME, t2.NAME AS NAME1
FROM TOVARS_TBL AS t1 LEFT OUTER JOIN TOVAR_UNITS AS t2 ON t1.UNIT_ID = t2.ID
WHERE t1.FOLDER_ID IN (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Вывоз')
ORDER BY TOVAR_ID;
SELECT t1.TOVAR_ID, t1.NAME
FROM TOVARS_TBL AS t1 INNER JOIN TOVAR_UNITS AS t2 ON t1.UNIT_ID = t2.ID
WHERE t2.NAME LIKE '%шт%' ORDER BY TOVAR_ID;
UPDATE TOVARS_TBL
SET FOLDER_ID = (SELECT FIRST 1 FOLDER_ID FROM TREE WHERE NAME = 'Вывоз')
WHERE FOLDER_ID IN (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Мытье');
Исходная версия Darth_Revan, :
SELECT TOVAR_ID, NAME FROM TOVARS_TBL
WHERE FOLDER_ID IN (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Мытье')
ORDER BY CODE;
SELECT t1.TOVAR_ID, t1.NAME, t2.NAME AS NAME1
FROM TOVARS_TBL AS t1 LEFT OUTER JOIN TOVAR_UNITS AS t2 ON t1.UNIT_ID = t2.ID
WHERE t1.FOLDER_ID IN (SELECT FOLDER_ID FROM TREE WHERE NAME = 'Вывоз')
ORDER BY TOVAR_ID;
SELECT t1.TOVAR_ID, t1.NAME
FROM TOVARS_TBL AS t1 INNER JOIN TOVAR_UNITS AS t2 ON t1.UNIT_ID = t2.ID
WHERE t2.NAME LIKE '%шт%' ORDER BY TOVAR_ID;
UPDATE TOVARS_TBL
SET FOLDER_ID = (SELECT FIRST 1 FOLDER_ID FROM TREE WHERE NAME = 'Вывоз')
WHERE FOLDER_ID = (SELECT FIRST 1 FOLDER_ID FROM TREE WHERE NAME = 'Мытье');