08-11-21, 12:14 PM
كود :
SELECT Currency_Directory.*, Cost_Center.Center_No, Cost_Center.Center_Name
FROM (SELECT Accounting_Manual.Account_No, Accounting_Manual.Account_Name, coins.coins_code
FROM Accounting_Manual LEFT JOIN coins ON Accounting_Manual.coins_No = coins.coins_no
WHERE Accounting_Manual.Rank = 5 AND coins.Active = True AND Accounting_Manual.Account_Stop = False) as Currency_Directory, Cost_Center
where cost_center.center_no= ( SELECT max(center_no) from cost_center where type_center_main_sub=2 and stop_center=0 )مع نصيحتي بعدم استخدام استعلام معقد بهذ الشكل انما استخدام استعلامات منفصلة
