Skip to Content
0
Jul 14, 2010 at 09:09 AM

Join on future criterias

24 Views

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