[progress Communities] [progress Openedge Abl] Forum Post: Re: Outer Apply From Crystal...

[marian.edu]

That’s simply because cross/outer apply is a sql server thingy and not an SQL standard, you can probably get along with a regular (outer) join here… select tag_rec."tag-num", tag_detail."tag-num" , pro_duct.desc2 as 'Size', tag_rec.desc2 as 'TRLength' from tag_rec inner join pro_duct on pro_duct.product = tag_rec.product outer join tag_detail on tag_detail."tag-num" = tag_rec."tag-num” Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212

Continue reading...