Here's my post content, rant rant rant... --
select c.c_content,u.u_name from Comment c,User u WHERE c_p_id = 1 AND c.c_u_id = u.u_id
- This is my comment to your post -- John Doe
- Well I agree -- Mickey Mouse
- Well I disagree -- Minnie Mouse
Here is another post --Minnie Mouse
select c.c_content,u.u_name from Comment c,User u WHERE c_p_id = 2 AND c.c_u_id = u.u_id
- comment1 -- John Doe
- comment2 -- Jane Doe
- comment2 again -- Jane Doe