SQL statement in VFP - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL statement in VFP

Message

From

22/08/2008 11:53:02

Bob Flanagan
Bpit, Inc.
Bethel, Connecticut, United States

22/08/2008 10:40:44

Sergey Berezniker
New York, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SQL statement in VFP

Environment versions

Visual FoxPro:

VFP 8 SP1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01341107

Message ID:

01341145

Views:

Sergey,

Thank you.

>Bob,
>
>Make sure to put approprite # of '0' in the IIF
>

>SELECT  ;
>	ord.OrderID, ;
>	SUM( IIF(shp.ShipDate <  ldFromDate, shp.ShipAmt, 000000000.00)) AS ShipAmtBefore, ;
>	SUM( IIF(shp.ShipDate >= ldFromDate, shp.ShipAmt, 000000000.00)) AS ShipAmtAfter ;
>  FROM Order ord
>     JOIN Shipment shp ON ord.OrderID = shp.OrderID ;
>GROUP BY ord.OrderID		
>

Map

View

Click here to load this message in the networking platform