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: 154
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