Problem in Join two tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • younker1983
    New Member
    • Dec 2007
    • 1

    #1

    Problem in Join two tables

    Hi, please help me to sortout this problem..... I have two tables (category and Members)


    Tables are like this



    Thanks
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Originally posted by younker1983
    Hi, please help me to sortout this problem..... I have two tables (category and Members)


    Tables are like this



    Thanks
    Hi Younker1983,

    Welcome to TSDN!!

    Could you please post your table structure here rather than providing the link for our experts to visit?

    All the experts here are professionals working in various big organizations and in most of the organizations the blog websites are blocked.

    MODERATOR

    Comment

    • Shalini Bhalla
      New Member
      • Dec 2007
      • 190

      #3
      hi ,
      I have not seen table structure but if you can chage the stored data as

      cat_id cat_name
      1 sin-music dir-Lyric

      2 singer-music dir

      3 music-dir--sing


      Like this you can solve your problem

      Comment

      • mwasif
        Recognized Expert Contributor
        • Jul 2006
        • 802

        #4
        Originally posted by younker1983
        Hi, please help me to sortout this problem..... I have two tables (category and Members)
        What you have tried so far?

        Comment

        • t3chn0n3rd
          New Member
          • Dec 2007
          • 19

          #5
          can you join on CAT_ID and MEMBER_ID

          Comment

          • Shalini Bhalla
            New Member
            • Dec 2007
            • 190

            #6
            Sorry for replying late ....
            Hapy new Year ...

            Any ways , You can not because join feilds should cantain same type of data in it . that is why i told you that if you can chage your data in category table it would be more easier for you .....



            regards
            shalini

            Comment

            Working...