Thursday, 12 April 2012

how to implement outer Join?

Ques--how to implement outer Join?
Ans--select Poassign_account.Project_Code,
       Poassign_account.Vendor_Name,
       Poassign_account.Job_Type,
       Invoice_No.Project_Code,
       Invoice_No.Invoice_No,
       Invoice_No.Po_No
       from
       Poassign_account right outer join Invoice_No on Poassign_account.Project_Code=Invoice_No.Project_Code

No comments:

Post a Comment

What is ASP.NET? Components of ASP.NET

ASP.Net Definition -It is used for creating web-based applications.ASP.Net is a web development platform provided by Microsoft. ASP.NET i...