I have this table:
p_id        name      skills
 1         Sam       #IT #communication #administration
 2         Alex      #French #Trainer 
 i want an sql query to output this
  ID     p_fid   skill
    1      1       IT
    2      1       communication
    3      1       administration 
    4      2       French
    5      2       Trainer
 im using MS Access, but i would use a different RDBMS if Access can't do this and another RDMS can
Thanks a lot
 
No comments:
Post a Comment