My query is **** and I'm over my head!
Hey all,
I'm fairly new at this an need a little direction. My query (below Number1) gives me crappy results where I get repeating lines (below Number2). A friend of mine told me that if you get multiple items you need to join your items table(mtl_system_items) to get the one true item. I check the items table and found my item in multiple orgs but not the org these orders are from. I'm confused and more than a little frustrated on what to do to get the correct results. (below Number3)
Number1:
Select distinct pol.item_id,oeh.order_number,oeh.attribute5 MM,oeh.BOOKED_DATE, oel.attribute7 ETA, oel.ATTRIBUTE8 ETD,apd.rcv_transaction_id,
I'm fairly new at this an need a little direction. My query (below Number1) gives me crappy results where I get repeating lines (below Number2). A friend of mine told me that if you get multiple items you need to join your items table(mtl_system_items) to get the one true item. I check the items table and found my item in multiple orgs but not the org these orders are from. I'm confused and more than a little frustrated on what to do to get the correct results. (below Number3)
Number1:
Select distinct pol.item_id,oeh.order_number,oeh.attribute5 MM,oeh.BOOKED_DATE, oel.attribute7 ETA, oel.ATTRIBUTE8 ETD,apd.rcv_transaction_id,
0