MySQL multi-table query is an error
You are good, I do the forum in which there are three of the table, that is, in the reply page display, just like this page, but the right reply to the content can be queried from the data table, but the left of the reply to the basic information, can only query out one, that is, all the reply to the user's basic information is the same:
My table structure is like this, the main table, the reply table, the main fields in the user table
Main sticker topic: (Tid,topic,tcontent,tuname,ttime);
Reply Table reply: (rid,rtopic,rcontent,runame,rtime);
User table UESR: (Uid,uname,usex,ubirthday, etc.);
, where the main list contains the name of the subject (topic), the Reply table contains the subject Name field (Rtopic), and topic is the same as rtopic, and now I want to query the corresponding reply user (Rtopic) based on the name (rname) field of the reply topic. And then according to investigate the user name (Rname), from the user table (users) to investigate the corresponding (Rname) detailed information, please help solve the expert, thank you! It is best to give the SQL statement.
------Solution--------------------
SQL Code
