join from muliple column to one table
i have a table genrelink and other genere description in which following columns are there

    Genere link table :
    
    titleID
    GENID1
    GENID2
    GENID3
    GENID4
    GENID5
    
    GenereDesscription table
    
    GENID
    DESC


I want to get the Genere desciption of all GENID of Genere Link in one hit...Query




join from muliple column to one table
===

i have a table genrelink and other genere description in which following columns are there

    Genere link table :
    
    titleID
    GENID1
    GENID2
    GENID3
    GENID4
    GENID5
    
    GenereDesscription table
    
    GENID
    DESC


I want to get the Genere desciption of all GENID of Genere Link in one hit...Query



