How can I combine two select statements that do not have an equal number of
expressions???

Select a, b, c from tbl_1

Union

Select x, y, z, aa, bb, cc, dd from tbl_2

Then.. The desired results would be:

A, b, c, x, y, z, aa, bb, cc, dd

:)



MS Sql Server LazyDBA home page