Joining multiple table

  • Hello All,

    i have been battling with this for 2 weeks now, here is a situation

    i have 3 tables

    Idea_atttribute_schema (template of products)

    Am_data (consist of attributes data to products)

    purchase order( consist of different suppliers)

    How would i join this tables together by getting the products attributr data from (AM_data) to the Idea_attirbute table template from

    products from the purchase order table

    please be aware column names at the top of each data

    i will really appreciate anyone who can help, this project is due today

    thanks

    (AM_data) ATTRIBUTES TO PRODUCTS

    Record_IDManufacturer_NameSellerID_QualifierSeller_IDTimeStampUpdateStatusIDW_IndexIDUPCGTINEAN_UCC-13Catalog_NumberUNSPSCAttribute_NameAttribute_ValueAttribute_UOMIGCC

    AM1.1 Southwire Company 132644212/4/2015 11:50C 88709243288603887732886038877NULL5503950226121636Conductor Size 12AWG 1789

    AM1.1 Southwire Company 132644212/4/2015 11:50C 88709243288603887732886038877NULL5503950226121636_Insulation Material NULLNULL1789

    AM1.1 Southwire Company 132644212/4/2015 11:50C 88709243288603887732886038877NULL5503950226121636Number Of Conductors 3NULL1789

    AM1.1 Southwire Company 132644212/4/2015 11:50C 88709243288603887732886038877NULL5503950226121636Outside Diameter 5980MILS 1789

    IDEA ATTRIBUTE TEMPLATE TABLE

    Added_In_or_Changed_InKeyUNSPSCSegmentFamilyClassCategoryGranular_CategoryIDEA_Granular_Category_CodeCategory_DefinitionAttribute_1Attribute_2Attribute_3Attribute_4Attribute_5Attribute_6Attribute_7Attribute_8Attribute_9Attribute_10Attribute_11Attribute_12Attribute_13Attribute_14Attribute_15Attribute_16Attribute_17Attribute_18Attribute_19Attribute_20Attribute_21Attribute_22Attribute_23Attribute_24Attribute_25Attribute_26Attribute_27

    Version 3 10082215121902Fuels and Fuel Additives and Lubricants and Anti corrosive Materials Lubricants and oils and greases and anti corrosives Greases Grease NULL1052NULLBrand Name Sub Brand Type Special Features Application Standard Size Temperature Range Specific Gravity VOC Flash Point Pour Point Dropping Point Odor Color Flammability Base Appearance ISO Viscosity Grade Plastic Safe Working Temperature NSF Category Code

    Version 3 14595415121905Fuels and Fuel Additives and Lubricants and Anti corrosive Materials Lubricants and oils and greases and anti corrosives Greases Thermal grease NULL1053A substance that increases thermal conductivity between the surfaces of two or more objects. Also called thermal compound, heat paste, thermal paste, or heat sink compound. Brand Name Sub Brand Type Special Features Application Standard Size Temperature Range Specific Gravity VOC Flash Point Pour Point Dropping Point Odor Color Flammability Base NLGI Grade

    Version 3 13617320101617Mining and Well Drilling Machinery and Accessories Mining and quarrying machinery and equipment Screens and feeding equipment Gearmotors NULL1054NULLBrand Name Sub Brand Type Special Features Application Standard Rotation Mounting Finish Gear Seals RPM Range Bearings Lubrication Shaft Gear Ratio Insulation Class Enclosure Length Less Shaft Shaft Dimensions

    Version 3 13634320102007Mining and Well Drilling Machinery and Accessories Mining and quarrying machinery and equipment Exploration and development systems Core drills NULL1055NULLBrand Name Sub Brand Type Special Features Application Standard Overall Depth Base Size No Load Speed Column Diameter Column Height Amperage Rating Motor Power Overall Height Included

    Version 3 10088020111603Mining and Well Drilling Machinery and Accessories Well drilling and operation equipment Drilling and operation machinery Hammer drills NULL1056NULLBrand Name Sub Brand Type Special Features Application Standard Corded Amperage Rating Bearings Length Reversing Chuck Size No Load Speed

    Version 4 10088020111603Mining and Well Drilling Machinery and Accessories Well drilling and operation equipment Drilling and operation machinery NULLHammer drill (battery) 1057NULLBrand Name Sub Brand Type Special Features Application Standard Corded Amperage Rating Bearings Length Reversing Chuck Size No Load Speed NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

    Version 4 10088020111603Mining and Well Drilling Machinery and Accessories Well drilling and operation equipment Drilling and operation machinery NULLHammer drill (electric) 1058NULLBrand Name Sub Brand Type Special Features Application Standard Corded Amperage Rating Bearings Length Reversing Chuck Size No Load Speed NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

    PPO TABLE (PRODUCTS TABLE)

    SupplierLINE_NOQUANTITYITEM_PART_NODESCRIPTIONUPC_NOCOST_PER_E_C_MGOODS_TOTALCARTON_QTYIDW INFO_Y_NCategoryUNITSTDPURCHASED_QTYSOLD_QTYUOMRATEAMOUNT

    CABLOFIL 1NULLC54/100EZ2" x 4" cable tray section 800388000249.78NULLEach NULLNULLNULLNULLNULLNULLNULL

    CABLOFIL 2NULLCF54/150EZ2" x 6" cable tray section 800388000254.6NULLEach NULLNULLNULLNULLNULLNULLNULL

    CABLOFIL 3NULLCF54/300EZ2" x 12" cable tray section 800388000368.37NULLEach NULLNULLNULLNULLNULLNULLNULL

    CABLOFIL 5NULLCF105/150EZ4" x 6" cable tray section 800388000762.05NULLEach NULLNULLNULLNULLNULLNULLNULL

  • I am finding your question difficult to follow. Can you take a look at the first link in my signature and then provide your consumable sample data, with DDL and desired results please?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply