Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT using Multiple Join Conditions
Message
From
16/03/2006 11:20:41
Steven Dyke
Safran Seats USA
Texas, United States
 
 
To
16/03/2006 10:59:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SPT using Multiple Join Conditions
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01104883
Message ID:
01104915
Views:
12
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.'
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform