Create a view from unrelated tables.

[raven4]

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.

 

[gmmastros]

Try this:

Select * From TableA Cross Join TableB

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[raven4]

Excellent. Thanks so much, George.