larry price wrote:
To get what you want from straight SQL
I think you end up doing either a bunch of subqueries (one per dept)
or an equally convoluted join.
The syntax bit you are looking for is
select table.column as alias_name
Hmmmm... not the syntax I had in mind....
How do you translate a table like this:
Matt 1 A
Matt 2 B
Matt 3 C
Larry 2 A
Joe 1 B
Joe 3 C
into:
Name A B C
Matt 1 2 3
Larry 2
Joe 1 3
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
EUGLUG mailing list
[email protected]
http://www.euglug.org/mailman/listinfo/euglug
