Good noon to every one my query is that i have one table name Purchase&Sales and two different field Purchase Sales the data which will be in Purchase text box will be fetch from Total purchase table and the data will be in sales table will be fetch from Total Sales Table means the both Value will come from different table to one table So please Give me a syntax or some idea Hoping for your Great and positive response
2
-
Did you try anything?Adarsh Kumar– Adarsh Kumar2013-10-03 10:56:13 +00:00Commented Oct 3, 2013 at 10:56
-
You can use join in query.Sain Pradeep– Sain Pradeep2013-10-03 10:58:21 +00:00Commented Oct 3, 2013 at 10:58
Add a comment
|
3 Answers
select sum(Purchase) Result from PurchaseTable
union all
select sum(Sales) Result from SalesTable
Comments
Using JOIN or try with ForeignKey concept if any.
Comments
SELECT
S.Total, -- selecting from one table
P.Total -- selecting from another table
FROM
Sales S
INNER JOIN -- inner join if you can or similar
Purchase P
ON
S.PurchaseId = P.ID
see here for more info http://www.techrepublic.com/article/sql-basics-query-multiple-tables/
