Query needed to link between 2 tables

Question

0.00/5 (No votes)

See more:

Table 1
Purchased_Items

Contains :
Item_ID:Number
Item_Quantity:Number

Table 2
Sold_Items

Contains :
Item_ID:Number
Item_Quantity:Number

How can I make a summation between two tables in (Item_Quantity), without inner join , these is a case should be handled if an item located in table 1 but not in table 2 , the is a value should be shown and vice versa , which is in table 1

Please help .

Posted 18-Sep-12 7:14am

besthms

Add a Solution

Comments

Herman<T>.Instance 18-Sep-12 15:09pm

why not an inner join? Have you tried Cross Join?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2012-09-18T07:40:00

If you would like to get purchased items which are not sold, use this query:

SQL

SELECT *
FROM Purchased_Items
WHERE NOT Item_ID IN (SELECT Item_ID FROM Sold_Items)

If you would like to sum Item_Quantity for both tables:

SQL

SELECT 'Sum Of Purchased_Items' As [Item Description], SUM(Item_Quantity) AS [Item Value]
FROM Purchased_tems
UNION ALL
SELECT 'Sum Of Sold_Items' As [Item Description], SUM(Item_Quantity) AS [Item Value]
FROM Purchased_tems

Example output:

Item Description	Item Value
Sum Of Purchased_Items	5,000.00
Sum Of Sold_Items	2,000.00

Query needed to link between 2 tables

1 solution

Solution 1

Add your solution here

Preview 0

Query needed to link between 2 tables

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us