SQLEXEC with Inner Join - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQLEXEC with Inner Join

Message

From

22/06/2007 05:21:10

Jojo Dela Cuesta
Dalplus Technologies
Bandar Seri Begawan, Brunei

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

SQLEXEC with Inner Join

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Firebird

Miscellaneous

Thread ID:

01234927

Message ID:

01234927

Views:

This code was giving me an error, What's wrong with it?

SQLEXEC(lnHandle, "SELECT TAlias1.PIF_NAME, TAlias2.PIF_ID FROM CLIENTS AS TAlias1 INNER JOIN PAYMENTS AS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID", "CPAY")

Thanks.

Jojo R. dela Cuesta, B.Sc.
eConsultant, Programmer
Dalplus Technologies
http://www.dalplus.com

Map

View

Click here to load this message in the networking platform