..يامبرمجين..
فين اضيف كود SQL الخاص بإنشاء علاقة بين الجداول ..الكود عندي بس فين اضيفوا ..
SELECT
FROM DiscountCards, (Users INNER JOIN ((StuffUsed INNER JOIN (StuffEntry INNER JOIN (Store INNER JOIN (Stuff INNER JOIN (Selaf INNER JOIN (((((Employees INNER JOIN DayOff ON Employees.Emp_ID = DayOff.Dof_EmpID) INNER JOIN Grama ON Employees.Emp_ID = Grama.Grm_EmpID) INNER JOIN Others ON Employees.Emp_ID = Others.Otr_EmpID) INNER JOIN Payment ON (Employees.Emp_ID = Payment.Pay_EmpID) AND (Others.Otr_ID = Payment.Pay_Otr_ID) AND (Grama.Grm_ID = Payment.Pay_Grm_ID) AND (DayOff.Dof_ID = Payment.Pay_Dof_ID)) INNER JOIN Sales ON Employees.Emp_ID = Sales.Sal_Emp_ID) ON (Employees.Emp_ID = Selaf.Slf_EmpID) AND (Selaf.Slf_ID = Payment.Pay_Slf_ID)) ON (Stuff.Stf_ID = Sales.Sal_Stuff_ID) AND (Stuff.Stf_ID = Sales.Sal_Sfen_ID)) ON Store.Str_ID = Stuff.Stf_StoreID) ON (Stuff.Stf_ID = StuffEntry.Sfen_StuffID) AND (StuffEntry.Sfen_ID = Stuff.Stf_Sfen_ID)) ON (Stuff.Stf_ID = StuffUsed.Stu_StuffID) AND (StuffUsed.Stu_ID = Stuff.Stf_Stu_ID)) INNER JOIN Takeem ON Employees.Emp_ID = Takeem.Tak_EmpID) ON Users.Usr_ID = Sales.Sal_CreaterID) INNER JOIN (Services INNER JOIN (ServicesDetails INNER JOIN (EmpSrv INNER JOIN Orders ON (EmpSrv.ES_EmpID = Orders.Ord_Emp3_ID) AND (EmpSrv.ES_EmpID = Orders.Ord_Emp2_ID) AND (EmpSrv.ES_EmpID = Orders.Ord_Emp1_ID)) ON ServicesDetails.SrvD_ID = Orders.Ord_SeviceID) ON Services.Srv_ID = ServicesDetails.SrvD_ServiceID) ON Users.Usr_ID = Orders.Ord_Creater_ID; :blink:
