Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access 2002 Query Problem
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Versions des environnements
Microsoft Office:
Office 2007
Divers
Thread ID:
01360953
Message ID:
01360965
Vues:
6
>>This query is giving me "Syntax error in FROM clause"
>>
>>
>>Dim s As String
>>s = "select qv.*, p.* FROM tblQuote_Version qv JOIN tblPlatforms p ON p.pk_Id = qv.PlatformTSAKey"
>>
>>
>>Anyone see what's wrong here?
>
>Try FROM myTable AS qv

No change.

It doesn't like the JOIN clause because this works:
Dim s As String
s = "select qv.*, p.* FROM tblQuote_Version, tblPlatforms p"
>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform