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

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -