I am new to SQL Server. I am just scratching the surface.I want to combine multiple tables into one \[code\]#View\[/code\]. My understanding is that if the number of columns are different we cannot use \[code\]UNIONS\[/code\] So can you guys please help me find the right solution?I have three tables 1.Table Name- Albums
2.Table Name-AlbumPictures
3.Table Name-Stories
I want to have 3 tables as follows
i can do this part using INNER JOINS- kindly correct me if i am wrong)For Stories: StoryID,AlbumID,StoryTitle,AlbumCover,VotesFor Albums: AlbumID,AlbumName,AlbumCover,VotesFor Pictures: AlbumPictureID,VotesNow i want to merge all the rows retrieved from the above queries into one view and shuffle them.As the number of columns are different in each of the resulsets above, i am unable to combine them into one \[code\]View\[/code\].This is where i am clueless.Am i making any sense?
i can do this part using INNER JOINS- kindly correct me if i am wrong)For Stories: StoryID,AlbumID,StoryTitle,AlbumCover,VotesFor Albums: AlbumID,AlbumName,AlbumCover,VotesFor Pictures: AlbumPictureID,VotesNow i want to merge all the rows retrieved from the above queries into one view and shuffle them.As the number of columns are different in each of the resulsets above, i am unable to combine them into one \[code\]View\[/code\].This is where i am clueless.Am i making any sense?