ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Fetched Combined Data from Two Tables in SQL Server<p>then your query must be like,</p> <p>&nbsp;</p> <pre class="brush: sql">select c.empid ,c.empname ,c.compname ,c.desig ,c.dept ,c.doj ,c.totsal ,c.npayable ,op.[Status] from emppersonal c inner join payslip op on c.empid = op.empid</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/194201/Fetched-Combined-Data-from-Two-Tables-in-SQL-Server/https://www.aspforums.net:443/Threads/194201/Fetched-Combined-Data-from-Two-Tables-in-SQL-Server/Thu, 20 Dec 2012 04:33:29 GMT