SQL query

[carrafan]

Assume i have a table with many columns, two of which are origin and destination. Is there a way to list out both columns in one single column?

 

Eg: If origin has (London, Baltimore, Chicago) and destination has (New York, Madrid, Chicago).. is there a way to make the table output a single column whose values are London, Baltimore, Chicago, New York, Madrid?

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[drdooom]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[carrafan]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited April 30, 2010 by carrafan

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here