Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-15 : 00:00:49
|
L.Nagarajan writes "I have two tables..
1.Receipts..
2.Issues
Receipts
--------
Rcpt Date
part_no
part_name
Rcpt_qty
unit_rate
Issues
------
Issue_date
part_no
Issued_qty
How to generate an SQL for this for a FIFO report.
I need..
rcpt.part_no issue_qty tot_rate" |
|
|
|
|
|
SQL Statement.