Member Avatar for ravikumar111

can any one give the code for join the table in left join method in phpmysql ?

  • 2 Contributors
  • 1 Reply
  • 64 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

Following query will give all student name which are in student table

select a.studid, a.studname, b.address, b.phone from student a left 
outer join address b on a.studid=b.studid

Following query will give only those student details which are in both table

select a.studid, a.studname, b.address, b.phone from student a inner join address b on a.studid=b.studid
Edited by urtrivedi because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.