Query to look up comment in one table, username in another table
- by John
Hello,
I am using a MySQL table called "login" with the following structure:
loginid, username, password, email, actcode, disabled, activated, created, points
I am using another MySQL table called "comment" with the following structure:
commentid, loginid, submissionid, comment, datecommented
For a given "submisssionid", I would like to…