Query problem
От | JAMES |
---|---|
Тема | Query problem |
Дата | |
Msg-id | 90o10u$da12@imsp212.netvigator.com обсуждение исходный текст |
Список | pgsql-general |
I have 3 tables, I want to show current stock quantity for each item. Table item <item_id> <item_name> <cost> <selling_price> P001 A4 Paper 10 12 P002 Pen 2 3 P003 Eraser 1 2 P004 Book 20 25 Table stock_out <item_id> <qty> <date> P001 4 11-NOV-00 P002 2 02-NOV-00 Table stock_in <item_id> <qty> <date> P001 10 01-OCT-00 P002 10 01-AUG-00 P003 10 01-JUL-00 P004 10 01-AUG-00 How can I show the following result? <item_id> <qty> P001 6 P002 8 P003 10 P004 10 THANKS James
В списке pgsql-general по дате отправления: