Retrieve the data from three different tables based two parameters in php mysql -
this tried :
select a.cs_id, a.class, b.sec_id, b.cs_id, b.cs_name, c.stud_id, c.stud_class, c.stud_section, c.stud_adm_no, c.stud_full_name class_section inner join section_name b on a.cs_id=b.cs_id inner join student_detail c on c.stud_class=b.sec_id a.cs_id=1
it's retrieving higher order variable only
select a.cs_id, a.class, b.sec_id, b.cs_name, c.stud_id, c.stud_class, c.stud_section, c.stud_adm_no, c.stud_full_name class_section inner join section_name b on a.cs_id=b.cs_id inner join student_detail c on c.stud_class=b.sec_id a.cs_id=1
may alias problem b
should b
c
should c
Comments
Post a Comment