Select query

Question

Post reply

Select query

biren

Right there with Babe

Points: 719
More actions
November 16, 2010 at 9:29 am

#226646

I have following table in my database
Brand Model Category ColorCode URL
Alain Mikli 800 Sunglasses Bluehttp://www.800.com
Burberry 900 Eyeglasses Black http://www.900.com
Bvlgari 500 Sunglasses Yellow http://www.500.com
And I want to write a select query which would display data in resultset as
Brand URL
Alain Mikli http://www.800.com
800 http://www.800.com
Sunglasses http://www.800.com
Blue http://www.800.com
Burberry http://www.900.com
900 http://www.900.com
Eyeglasses http://www.900.com
Black http://www.900.com
Bvlgari http://www.500.com
500 http://www.500.com
Sunglasses http://www.500.com
Yellow http://www.500.com
can anybody please help me with this !!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Richard Warr SSCertifiable Points: 6966 More actions · Answer 1

Hi Biren,

Something like

SELECT Brand,URL FROM Table

UNION

SELECT Model,URL FROM Table

UNION

SELECT Category,URL FROM Table

UNION

SELECT ColorCode,URL FROM Table

should do it. Are you concerned about the order of records?

biren Right there with Babe Points: 719 More actions · Answer 2

Hi,

I have attached an attachment, which would be easy to explain me how i want the data.

Thank You

John Rowan SSC Guru Points: 56440 More actions · Answer 3

In addition to what Joe has posted, please refer to the article in my signature line for assistance on creating a post with proper examples and sample data. Following these guidelines will make helping you much easier and faster.....help us help you.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden