SQL to return duplicate rows with one column

I am looking for some simple sql to convert a simple sql query which will return me some column values like this select ab,cd,ef,gh from alphabets which returns me ab cd ef gh -------------- a b c d what I actually want is to append something to this query that will return me same record but certain number of times with one differing value. ab cd ef gh -------------- a b x d a b y d a b z d Any help or guidance is appreciated. P.S. If anyone be able to show it how to do it in c# with sql mapping to object will be useful as well.Thanks alot.