Fetch Data from 2 table?

Question

User-1305858305 posted

Hello 

Is it possible to retrieve from 2 tables at the same time?

Bold letter explain what i need.

<asp:SqlDataSource ID="sqlDataSourceGridView" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT dia.*, Girdles.*, Shapes.*, Colors.*, ColorsLot.*, Cuts.*, Clarity.*, Polish.*, Sym.*, Fluo.*, Culet.*, Reports.*, Proportions.*, Categories.*           
            FROM Diamonds AS dia   //In here I need to fetch data from multiple diamonds table. Diamond1 Diamond2 Diamond3 etc      
            LEFT JOIN Shapes ON Shapes.ShapeID = dia.ShapeID             
           ....
            ORDER BY dia.DateAdd DESC"
            OnSelecting="sqlDataSourceGridView_Selecting">
            <SelectParameters>
                <asp:Parameter Name="Category" DefaultValue="2" />
                <asp:Parameter Name="Status" DefaultValue="2" />
                <asp:Parameter Name="Function" DefaultValue="1" />
                <asp:Parameter Name="Operation" DefaultValue="0" />
                <asp:Parameter Name="ReportIDs" />
                <asp:Parameter Name="ShapeIDs"/>                           
            </SelectParameters>
        </asp:SqlDataSource>

Answer 1

User197322208 posted

create a view that join the tables and retrieve data from the view

Answer 2

User-1305858305 posted

Thank you for reply and tip.

For searchers i want to be add a link about fetching data from multiple tables with View

http://dba.fyicenter.com/faq/sql_server/Creating_a_View_with_Data_from_Multiple_Tables.html

Regards