Saturday, 15 June 2013

view in sql server


==============================================================
View:-
==========================================================

CREATE VIEW InvoiceHeaders (customer_nbr, order_tot, ..)
AS
SELECT customer_nbr,
SUM(order_qty * unit_price),
..
FROM Invoices AS I, InvoiceDetails AS D
WHERE I.invoice_nbr = D.invoice_nbr
GROUP BY customer_nbr;
==============================================================

No comments:

Post a Comment