php mysql 两张表_在一个php页面中使用两个表（mysql）

Trying to retrieve all the data onto one page... I've got this working fine when it's retrieving from one table like so:

$data = mysql_query("SELECT * FROM moduleDetails")

I've tried doing

("SELECT * FROM moduleDetails, qResponses")

but that doesn't work and is the only thing I can see working.

I've heard about using identifiers? But I'm not quite sure how to use those...

I am new to PHP, any tips/examples would be great.

解决方案SELECT md.*, qr.*

FROM moduleDetails md

LEFT JOIN qResponses qr

ON qr.joinColumn = md.joinColumn

Whatever column you used to link them together, use as the joinColumn.