select DOC_No,Vendor,DOC, CASE when (a.Vendor <> '' and a.DOC_No = a.DOC) then a.Vendor ELSE '0' end from ( select a.DOC_No , a.Vendor,b.Doc,b.Val from [dbo].[Vendor_Table]a INNER JOIN [dbo].[Vendor]b ON a.DOC_No = b.DOC ) A
SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID WHERE Customers.CustomerName IS NOT NULL;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)