Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: katdan113
- Order by date
-
Lawson security model: CE 9, Oracle DB
SELECT "STPOLINE"."COMPANY", "STPOLINE"."ORDER_NAME", "STPOLINE"."ITEM", "STPOLINE"."LINE_NBR", "STPOLINE"."ENT_BUY_UOM", "STPOLINE"."ENT_UNIT_CST", "ITEMMAST"."ITEM", "ITEMMAST"."DESCRIPTION", "ITEMMAST"."DESCRIPTION2", "ITEMMAST"."MANUF_CODE", "ITEMMAST"."MANUF_DIVISION"...- katdan113
- Post #9
- Forum: Business Objects:Crystal Enterprise
-
Lawson security model: CE 9, Oracle DB
SELECT "STPOLINE"."COMPANY", "STPOLINE"."ORDER_NAME", "STPOLINE"."ITEM", "STPOLINE"."LINE_NBR", "STPOLINE"."ENT_BUY_UOM", "STPOLINE"."ENT_UNIT_CST", "ITEMMAST"."ITEM", "ITEMMAST"."DESCRIPTION", "ITEMMAST"."DESCRIPTION2", "ITEMMAST"."MANUF_CODE", "ITEMMAST"."MANUF_DIVISION"...- katdan113
- Post #8
- Forum: Business Objects:Crystal Enterprise
-
Lawson security model: CE 9, Oracle DB
Crystal 9.0 and or 10.0, Lawson software, oracle db. want all lines from a particular standing order(stpoline). I know this is 2451 records. Do outer left join to itemmast and still have 2451 records. Do left outer join again from stpoline to povenitem and lose 27 records because they do not...- katdan113
- Post #6
- Forum: Business Objects:Crystal Enterprise
