OK,that indeed seems to work,I initially wanted to ask this question using multiple columns & then when I finished writing the post realised I overcomplicated my question,so I simplified the statements for the create table but forgot the insert.