SQL Joining Tables and mapping columns

hi,

column name : table name: attribute1
po_vendor_sites_allsegment1
po_headers_allcreation_date
po_headers_allneed_by_date
po_line_locations_alllocation_code
hr_locations_allvendor_name
po_vendorssegment1
mtl_system_items_Bdescription
mtl_system_items_Bunit_meas_lookup_code
po_lines_allquantity
po_lines_allunit_price
po_lines_allunit_price*quantity
po_lines_allquantity_committed
po_lines_all

this is the input to generate the stucture,
i need to join these tables such that i should not get duplicates, also how to map the columns?

NOTE : [I][This question was asked by a visitor][/I]