Subquery in SELECT clause - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Subquery in SELECT clause

Message

From

01/08/2004 05:20:17

Fabio Lunardon
Lunacom
Marostica, Italy

To

31/07/2004 13:15:17

Sergey Berezniker
New York, United States

General information

Forum:

Visual FoxPro

Category:

Visual FoxPro Beta

Title:

Re: Subquery in SELECT clause

Miscellaneous

Thread ID:

00929817

Message ID:

00929945

Views:

9

Hi Sergey,

Like SQL Yukon's new PIVOT crosstab.

SELECT id,column_name,value FROM mytable PIVOT ( SUM(value) FOR column_name )

Click here to load this message in the networking platform