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  Transact-SQL (2000)  helppppppppppppppppppppp needed ..URGENT

Author  Topic  kiddz7 Starting Member 3 Posts Posted - 2001-09-25 : 09:37:38 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