I was shown the ease that one can make a view from multiple tables, GROUPing BY an id of one of the tables in xception's awesome answer here: CREATE VIEW WHERE SELECTid = VIEWrowID
Is there any way to do that in MS? Everywhere, I've read says "no", but no page gives an alternative.
I don't need the counts or anything, just multiple columns from multiple tables GROUPed BY(?) a single column on one table.
Thanks a lot in advance!
Thank-you for responding.
For the view's SELECT:
SELECT dbo.table1.column1 AS table1column1, dbo.table1.column2 AS table1column2, dbo.table2.column1 AS table2column1, dbo.table2.column2 AS table2column2 FROM table1, table2 WHERE table2.column1 = table1.column1 GROUP BY table1.column1