SQL Select -> product -> comments -> user

Posted by user1492716 on Stack Overflow See other posts from Stack Overflow or by user1492716
Published on 2012-06-30T08:12:33Z Indexed on 2012/06/30 9:16 UTC
Read the original article Hit count: 156

Filed under:
|

thanks for yout time helping on this ;) I'm new to SQL and wish to solve somethign in just one query and i dont know how to do it.-

Basically I've a table of products, a table of users and a table of comments, linked by products.id -> comments.pid and user.id -> comments.uid ,

i wish to know what is the best practice to create just 1 query and get all products with child comments, including username.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql