I'm not sure what the best way to do this is. Can it be done with select-sql?

I have a table with 2 fields. One field contains Customer drawing names, the other contains vendor drawing names, Both are character fields c(30).
mytable.fvdwg
mytable.fhdwg

I want to build a cursor that contains all fvdwg's and all fhdwg's and no duplicates, in one field. mycursor.fdwg

Can we merge 2 fields into one with select-sql or will I have to use traditional methods, create cursor, insert etc...