SQL: Is it possible to join two tables and use the same table(result of the join) to generate two aggregated tables using a stored procedure?
I have a scenario where I have to join two tables to generate two aggregated tables based on a certain level of aggregation. I need to use these two tables in c# asp.net code. So my question is if it is possible to join these two tables give an alias for it and generate two aggregated tables with the help of the alias ? Rather than doing two joins two generate datatables individually ?
SQL: Is it possible to join two tables and use the same table(result of the join) to generate two aggregated tables using a stored procedure?
===

I have a scenario where I have to join two tables to generate two aggregated tables based on a certain level of aggregation. I need to use these two tables in c# asp.net code. So my question is if it is possible to join these two tables give an alias for it and generate two aggregated tables with the help of the alias ? Rather than doing two joins two generate datatables individually ?