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
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