08-11-21, 02:25 AM
السلام عليكم
اريد دمج استعلامين
الاول
الثاني
اريد دمج استعلامين
الاول
كود :
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
كود :
SELECT Cost_Center.Center_No, Cost_Center.Center_Name
FROM Currency_Directory, Cost_Center
where cost_center.center_no= ( SELECT max(center_no) from cost_centre where type_center_main_sub=2 and stop_center=0 )