Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC with Inner Join
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Firebird
Miscellaneous
Thread ID:
01234927
Message ID:
01234994
Views:
10
Hi Borilav,

You're right, that was a valid SQL statement for MS SQL Server but not with Firebird.



>>>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.
>>
>>
>>You don't use AS to create a new table name, AFAIK, only for fields, e.g.
>>
>>select Field1 as NewField1, Field2 as NewField2 from Table1 T1 inner join ...
>>
>>So, your syntax may have been wrong.
>
>This is perfect valid SELECT:
>
>SELECT *
>      FROM Levels AS Test
>
>in SQL Server, but I see that
>Jojo use Firebird so they may have a different opinion about this :o)
Jojo R. dela Cuesta, B.Sc.
eConsultant, Programmer
Dalplus Technologies
http://www.dalplus.com
Previous
Reply
Map
View

Click here to load this message in the networking platform