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

matthew garrett matthew.garrett at snet.net
Fri Aug 17 16:51:51 CDT 2001


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?

> 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








More information about the thelist mailing list