3 Replies Latest reply: Sep 4, 2016 9:34 AM by Shaima Mahmoud RSS

    composite key

    Rahul Krishan Goyal

      Hello Everyone,

       

      Please help me.

       

      I have following tables and fields;

       

      max_stock:

      MainVesselTypeId,

      MainVesselId,

      stock

       

      Vessel:

      VesselId,

          Name      ///  vessel name

       

      VesselType:

      VesselTypeId,

          TypeName   // vessel type name

       

      Now, I want to create composite key connecting MainVesselTypeId with VesselTypeId and MainVesselId with VesselId and want to display vessel type name, vessel name and vessel stock. How can I do this using composite key.  Here, I cannot/do not want to use Apply Map function.


      Please help me .


      Thank You,


      Rahul Krishan Goyal