MySQL

[mitrad]

سلام.من یک query نوشتم اما کار نمیکنه.میشه کمکم کنید و بگید اشکال از کجاست؟

select prerequisites.LesCode, prerequisites.PreReqCode, prerequisites.FldCode,
lessons.PLesName,lessons.LesTotalUnit, lessons.LesTypCode,
presentedlessons.EduYear, presentedlessons.semester,
studentspecs.StNo
from prerequisites
left join lessons ON (prerequisites.LesCode=lessons.LesCode)
left join presentedlessons on (prerequisites.LesCode=presentedlessons.LesCode)
left join studentspecs on (prerequisites.FldCode=studentspecs.FldCode)
where studentspecs.StNo='8911210921' and prerequisites.FldCode='21';
union ALL
select grades.LesCode,prerequisites.PreReqCode,prerequisi tes.FldCode,
lessons.PLesName,lessons.LesTotalUnit,lessons.LesT ypCode,grades.EduYear,
grades.Semester, StNo, grades.grade,
from grades
left join lessons on (grades.LesCode=lessons.LesCode)
left join prerequisites on (grades.LesCode=prerequisites.LesCode)
where grades.StNo='8911210921'
Group By grades.LesCode;
ممنونم

[miladamirzadeh]

select prerequisites.LesCode, prerequisites.PreReqCode, prerequisites.FldCode,
lessons.PLesName,lessons.LesTotalUnit, lessons.LesTypCode,
presentedlessons.EduYear, presentedlessons.semester,
studentspecs.StNo
from prerequisites
left join lessons ON (prerequisites.LesCode=lessons.LesCode)
left join presentedlessons on (prerequisites.LesCode=presentedlessons.LesCode)
left join studentspecs on (prerequisites.FldCode=studentspecs.FldCode)
where studentspecs.StNo='8911210921' and prerequisites.FldCode='21';
union ALL
select grades.LesCode,prerequisites.PreReqCode,prerequisi tes.FldCode,
lessons.PLesName,lessons.LesTotalUnit,lessons.LesT ypCode,grades.EduYear,
grades.Semester, StNo, grades.grade,
from grades
left join lessons on (grades.LesCode=lessons.LesCode)
left join prerequisites on (grades.LesCode=prerequisites.LesCode)
where grades.StNo='8911210921'
Group By grades.LesCode;



میشه پیغام خطاشو بگی؟ وقتی از تگ های CODE و SQL استفاده می کنی هم سوالت خواناتر می شه هم فروم قشنگ تر!

[mitrad]

select prerequisites.LesCode, prerequisites.PreReqCode, prerequisites.FldCode,
lessons.PLesName,lessons.LesTotalUnit, lessons.LesTypCode,
presentedlessons.EduYear, presentedlessons.semester,
studentspecs.StNo
from prerequisites
left join lessons ON (prerequisites.LesCode=lessons.LesCode)
left join presentedlessons on (prerequisites.LesCode=presentedlessons.LesCode)
left join studentspecs on (prerequisites.FldCode=studentspecs.FldCode)
where studentspecs.StNo='8911210921' and prerequisites.FldCode='21';
union ALL
select grades.LesCode,prerequisites.PreReqCode,prerequisi tes.FldCode,
lessons.PLesName,lessons.LesTotalUnit,lessons.LesT ypCode,grades.EduYear,
grades.Semester, StNo, grades.grade,
from grades
left join lessons on (grades.LesCode=lessons.LesCode)
left join prerequisites on (grades.LesCode=prerequisites.LesCode)
where grades.StNo='8911210921'
Group By grades.LesCode;



میشه پیغام خطاشو بگی؟ وقتی از تگ های CODE و SQL استفاده می کنی هم سوالت خواناتر می شه هم فروم قشنگ تر!
ممنون این رو خودم حلش کردم