I have Table A that contains: ID, Name
I have Table B that contains: RelationType
I want to be able to create a view that shows one row for each ID in Table A for each of the RelationTypes in Table B. So if there are three different RelationTypes, my results would be:
ID RelationType
100 Father
100 Mother
100 Mentor
200 Father
200 Mother
200 Mentor
300 Father
300 Mother
300 Mentor
Thanks.
I have Table B that contains: RelationType
I want to be able to create a view that shows one row for each ID in Table A for each of the RelationTypes in Table B. So if there are three different RelationTypes, my results would be:
ID RelationType
100 Father
100 Mother
100 Mentor
200 Father
200 Mother
200 Mentor
300 Father
300 Mother
300 Mentor
Thanks.