• Simple enough with a union

    select Job ,Name1_1 ,city1_1 , phone1_1

    from table

    union all

    select Job ,Name1_2 ,city1_2 , phone1_2

    from table

    union all

    select Job ,Name1_3 ,city1_3 , phone1_3

    from table

    union all

    select Job ,Name1_4 ,city1_4 , phone1_4

    from table



    Clear Sky SQL
    My Blog[/url]