SELECT c_car.car_id, c_act.*, c_tax.*, c_insurance.*, c_company.*, c_company_1.*, c_company_1.company_name AS com FROM c_company AS c_company_1 RIGHT JOIN (c_company RIGHT JOIN ((c_car LEFT JOIN (c_act LEFT JOIN c_tax ON c_act.act_no = c_tax.act_no) ON c_car.car_id = c_act.car_id) LEFT JOIN c_insurance ON c_car.car_id = c_insurance.car_id) ON c_company.companyid = c_act.companyid) ON c_company_1.companyid = c_insurance.companyid
WHERE YEAR(c_act.act_Enddate) in (2014) OR YEAR(c_tax.tax_Enddate) in (2014) OR YEAR(c_insurance.Ins_Enddate) in (2014)
รบกวนด้วยน้ะครั้บบ ขอบคุนทุกท่านๆครับผม
Tag : .NET, MySQL, C#
Date :
2014-08-28 21:22:14
By :
ozil
View :
932
Reply :
4
No. 1
Guest
Code (SQL)
WHERE YEAR(c_act.act_Enddate) in (2014) OR YEAR(c_tax.tax_Enddate) in (2014) OR YEAR(c_insurance.Ins_Enddate) in (2014)