3 messages in com.mysql.lists.perlRe: Query Question
FromSent OnAttachments
Douglas S. Davis16 Jan 2006 08:24 
Michael Stassen16 Jan 2006 08:41 
Douglas S. Davis16 Jan 2006 08:47 
Subject:Re: Query Question
From:Douglas S. Davis (dsda@haverford.edu)
Date:01/16/2006 08:47:02 AM
List:com.mysql.lists.perl

Thanks, Michael,

I'll follow the thread on the other list for help.

I'll also try to work with the answer you gave me.

Thanks!

Douglas

At 11:42 AM 1/16/2006, Michael Stassen wrote:

SELECT p1.name AS Subject, c.comment AS Quote, p2.name AS Source FROM Profiles p1 LEFT JOIN Comments c ON p1.id = c.user_id LEFT JOIN Profiles p2 ON c.poster_id = p2.id;