>>>
>>>Thank you for clarifying. Sorry that I didn't pay attention to the semicolons. I will test this approach in both VFP and SQL Server. Initially I thought I would do it using a Function (with pretty much similar code that you wrote). But view is probably better approach (although I don't yet understand why).
>>
>>
>>> But view is probably better approach (although I don't yet understand why).
>>
>>
>>I think it is because a view is faster.
>>
>>btw - I have used nvl() in case there are no invoices yet. I think the sqlserver equivalent is ISNULL() http://msdn.microsoft.com/en-us/library/ms184325.aspx
>
>Thank you for the NVL() and ISNULL() explanation.

If you want to do it for particular Order, you have two choices. Select * from OrdersView where OrderID = @OrderId

or alternatively create the above as a table values inline function, so it will be

select * from dbo.OrdersInfo(@OrderID)