Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
What's tripping me up here?
I'm missing the syntax error in the following statement. Could one of the more experienced SQLers point to where I've wandered off the beaten path?
SELECT
Account."ID", Account."BOB_ID", Account."Profile_ID",
Account_Contact."Contact_ID", Account_Contact."Account_ID", Account_Contact."Type",
Household."Household_ID",
Contact."Contact_ID", Contact."First_Name", Contact."Relationship",
Profile_Member."Owning_Profile_ID", Profile_Member."Member_Profile_ID"
FROM
{ oj ((("wcc"."Account" Account INNER JOIN "wcc"."Household" Household ON
Account."Profile_ID" = Household."Household_ID")
INNER JOIN "wcc"."Account_Contact" Account_Contact ON
Account."ID" = Account_Contact."Account_ID")
INNER JOIN "wcc"."Profile_Member" Profile_Member ON
Household."Household_ID" = Profile_Member."Member_Profile_ID")
INNER JOIN "wcc"."Contact" Contact ON
Account_Contact."Contact_ID" = Contact."Contact_ID"}
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