Hi
I have a join in MSEG where I want to include NAST based on the purchase order.
The criteria is that I only want one line MSEG and only one line in NAST it exists. Also the NAST line sould be the youngest line there exists.
In Oracle I could do this with a subselect but can I do something similary in OPEN SQL.
Daniel