Re: Query Question - Douglas S. Davis - com.mysql.lists.perl

3 messages in com.mysql.lists.perlRe: Query Question

From	Sent On	Attachments
Douglas S. Davis	16 Jan 2006 08:24
Michael Stassen	16 Jan 2006 08:41
Douglas S. Davis	16 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;