General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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"}
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only