🔒 Closed Joining table on PHP , MYSQL

[Reverse Engineer]

Pa help po sa syntax ng pag join ng tables

$query = "SELECT * FROM tblstudent s, tblcourse c,tbldepartment d, tblstrand b WHERE s.COURSE=c.COURSEID AND s.STRAND=b.STRANDID s.DEPARTMENT=d.DEPARTMENTID";

 

[k4rm4]

Basahin at pagaralan mo paps. JOINT or INNER JOINT

 

[dee-u]

Parang ganito

SELECT * FROM tblstudent s INNER JOIN tblcourse c ON s.COURSE=c.COURSEID

INNER JOIN tbldepartment d ON s.DEPARTMENT=d.DEPARTMENTID

INNER JOIN tblstrand b ON s.STRAND=b.STRANDID

 

[Reverse Engineer]

nauuna po ba talaga s.Department =d.Departmentid sa SELECT sir? Newbie po thank you in advance po

 

[Heizengberg]

SELECT * FROM tblstudent s, tblcourse c,tbldepartment d, tblstrand b INNER JOIN s.COURSE=c.COURSEID INNER JOIN s.STRAND=b.STRANDID INNER JOIN s.DEPARTMENT=d.DEPARTMENTID

 

[Heizengberg]

may error ba sa query mo?

 

[Kilaaa]

[XX='Em EL, c: 973083, m: 1754432'][/XX] unahin mo muna yung SELECT

 

[dee-u]

[XX='Em EL, c: 973083, m: 1754432'][/XX] Try mo, na-edit ko na, naiwan yata yung nahalong text nung nagcopy-paste ako.

 

[Reverse Engineer]

Try ko po ito lods. Salamat po sa tulong

 

[Reverse Engineer]

Salamt po sainyo mga idol. Salamat po talaga