hi
you can try this ,
<asp:GridView ID="grd" runat="server" CaptionAlign="Top" Width="100%" SelectedIndex="0" CellPadding="4"
AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px"
GridLines="Vertical" ForeColor="Black">
<Columns>
<asp:TemplateField HeaderText="Select Record">
<ItemTemplate>
put controls here like:
<asp:label id="lblLabel" runat="server" text="<%# Bind("tableColumn") %>" xmlns:asp="#unknown"></asp:label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
Apply join query on both tables assign the result into some dataTable which is having result of all data.
assign it to grd.DataSource and call grd.DataBind();
this will be the one way where you can bind the columns of query result to the gridview...
Or you can retreive join result and simply use following logic.
some DataTable object=result of your join query; //or you can use dataAdapter and Dataset also
grd.DataSource=some table;
grd.DataBind()