Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Michael,
Thanks for the info. On a related note, I have another question. (Sorry if this should go in another thread)
I know that using the *= syntax is considered outdated. But I tried this:
select distinct arcust.ccustno, sosord.ccustno as xcustno from arcust, sosord where arcust.ccustno *= sosord.ccustno
in t-sql and vfp. I get 'missing operand' in vfp 6. I seem to recall doing queries this way in foxpro several years ago? Am I mistaken.
>The additional FROM is a TSQL Extension, it is not supported by ANSI SQL.
>
>-Mike
>
>
>>I am writing a T-SQL stored procedure that uses the FROM clause in an update statement. I wanted to test the equivalent functionality in VFP. But then I looked at the VFP help and realized that it does not appear to be supported in vfp 6 or 7. How about in 8?
>>
>>How can I update rows in one table in vfp based upon a join condition on two tables?
>>
>>TIA
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement