cartisian product queries? 1

[MikeDNova]

hey guys,

i have two tables
tblCategoryResponse
priority - 7 entries
response - 7 entries

tblQuestion
CategoryID
QuestionID
Question
QuestionType


tblQuestionResponse
QuestionID
CategoryID
Response - Response
seqNo - Priority

i want to try to do a cartisian product query to append to the tblQuestionResponse table. I am trying to use the cartisian product to append the same response and priority entries from tblCategoryResponse, to tblQuestionResponse, for each question of QuestionType "Category."

I'm not sure how to even run this type of query in access.

any suggestions???

thanks in advance,
Mike

 

[r937]

a cartesian product is simply an inner join without the join condition

insert 
  into tblQuestionResponse
     ( QuestionID
     , CategoryID
     , Response 
     , seqNo
     )
select Q.QuestionID
     , Q.CategoryID
     , C.response 
     , C.priority
  from tblQuestion Q
     , tblCategoryResponse C

to make sure this is what you want, run the select part of it by itself first

rudy

http://rudy.ca/