4-table join not returning all the data I need

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  May 28, 2008 at 2:34 pm

  #821468

  Without knowing the primary key and foreign keys, this will be difficult to solve. Here is guess at your schema:

  create table SurveyQuestions

  ( QuestionID

  PRIMARY KEY ( QuestionID ) )

  create table dbo.SurveyChoices

  ( QuestionId

  , AnswerID

  , AnswerText

  PRIMARY KEY ( QuestionID , AnswerID ) )

  Create table InstallCardCustomerInformation

  ( InstallCardId

  , InstallersMemberID

  , PRIMARY KEY (InstallCardId ) )

  create table SurveyResults

  ( InstallCardId

  , QuestionID

  , AnswerID

  , PRIMARY KEY ( InstallCardId , QuestionID , AnswerID )

  , FOREIGN KEY ( InstallCardId ) references InstallCardCustomerInformation

  , FOREIGN KEY ( QuestionID , AnswerID ) references SurveyChoices

  )

  Is this correct ?

  SQL = Scarcely Qualifies as a Language