Skip to Content
0
Former Member
Aug 25, 2009 at 04:04 PM

Extract data out of 2 database tables

16 Views

i have table 1 with values cost center = 100...500, and sub-cost-centers for Cost center

i have table 2 with values Business area assigned to Costcenters

now i want tof ind this data

Business area cost center sub-cost-center

a1...........................100..............100-11

a1...........................101..............100-12

a1...........................102..............100-13

a1...........................103..............100-14

a2...........................100..............100-11

a2...........................101..............100-21

a2...........................102..............100-22

a2...........................103..............100-23

what do i do?

i am in bi 7

i want to extract this information out in Excel