Re: Query Question

"Douglas S. Davis" <[email protected]> Mon, 16 Jan 2006 11:47:25 -0500

Newsgroups	gmane.comp.db.mysql.perl
Message-ID	<[email protected]>

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;

Douglas S. Davis
Programmer/Analyst
Haverford College
Administrative Computing
370 Lancaster Ave.
Haverford, PA 19041
610-896-4206 

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]