Hassle-free live chat software re-imagined for business growth. 2 users, always free.
Select Top(200)OrderRunId,OrderCustNum,OrderDate,OrderSum,OrderTM, OrderEmpNum,Orders.OrderNum,Manot,AspkaDate,Mifrat,CloseDate,CustName, (Select SUM(ISNULL(Quant,0)) From dbo.OrderDet where OrderDet.OrderNum = OrderRunId) as Quantity from Orders inner join dbo.OrderDet on OrderRunId = Orders.OrderNum inner join Customers on OrderCustNum=CustomerRunId order by OrderRunId desc
|T-SQL: Nested CASE Statements||4||21|
|SQL Query Syntax Join||4||23|
|SQL log file keeps growing despite getting successful log backups||4||18|
|SQL - How to list all tables participating in a query||7||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
6 Experts available now in Live!