SPT using Multiple Join Conditions

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SPT using Multiple Join Conditions

Message

16/03/2006 11:20:41

Steven Dyke
Safran Seats USA
Texas, États-Unis

16/03/2006 10:59:22

Cetin Basoz
Engineerica Inc.
Izmir, Turquie

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: SPT using Multiple Join Conditions

Versions des environnements

Visual FoxPro:

VFP 6 SP5

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

01104883

Message ID:

01104915

Vues:

I have tried:

getDrawingDataString = "Select * From drawmstrp Left Outer Join drawmext1 On drawmstrp.dm_drawing_number = drawmext1.dmdrawno Left Outer Join drawmext3 On drawmstrp.dm_drawing_number = drawmext3.dmdrawno

(to Add) And drawmstrp.dm_pending_change = drawmext3.prevchng

Where drawmstrp.dmdrawno = '" + PadR(whatDrawingNumber,12) + "'"

But I get an error 'Command contains unrecognized phrase/keyword.'

Répondre

Fil

Voir

Click here to load this message in the networking platform