[thelist] SQL Madness! Many-to-many selection

[Joshua Olson]

----- Original Message -----
From: "matthew garrett" <matthew.garrett at snet.net>
Subject: Re: [thelist] SQL Madness! Many-to-many selection


: Have I been sleeping? I can't remember seeing such an elegantly formatted
: SELECT clause. Makes it pretty easy to spot the missing commas, yes?


And, all you have to do is delete a line to delete it... you don't have to
remember to strip off the comma in the line above.


:
: > From: "rudy" <r937 at interlog.com>
:
: > SELECT category.url_path AS category_url_path
: > , category.name AS category_name
: > , event.id
: > , event.name
: > , event.introduction
: > , event.is_active
: > , event.date_begin
:
: Thanks Rudy - nice tip.
:
: matt