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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 NEED HELP. URGENT

Author  Topic 

kiddz7
Starting Member

3 Posts

Posted - 2001-09-25 : 09:31:23
how do i make a query for this:
Create a report showing each payment and the total cost for the relevant order

if i got this 3 tables:
payment:
(paynum,ordernum,pdate,pamount)
order line: (quantity,prodnum,ordernum,quotenum)
quote:
(quotenum,qdate, qprice)

hope u proffesional guys can help
thanks in advanced



   

- Advertisement -