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