Ordering alphabetical in secondary select string

[R.G. Vervoort]

Does anyone have a suggestion how I can order a list with names in a
secondary select string.

The first string selects a number of locations where people work

From this string I get several id's form people (in the location table there
are no names but id's form the people table) that work on those locations

No I make another select to get the name form the people table using the id
I got before.

I would like to have the table ordered alphabetical by the name of the
people

Since the number op people is very long is will be to slow working the other
way around (first selecting people and then looking for the location)

Example:

Location 1 Name A

Name B

Name C

Location 3 Name D

Name E

Location 5 Name F

Location 2 Name G

Location 9 Name H

Location 7 Name I

[Tim Van Wassenhove]

In article <40*********************@news.xs4all.nl>, R.G. Vervoort wrote:

Does anyone have a suggestion how I can order a list with names in a
secondary select string.

The first string selects a number of locations where people work
From this string I get several id's form people (in the location table there
are no names but id's form the people table) that work on those locations

No I make another select to get the name form the people table using the id
I got before.

I would like to have the table ordered alphabetical by the name of the
people
Since the number op people is very long is will be to slow working the other
way around (first selecting people and then looking for the location)

You might want to lookup what an INNER JOIN clause in a SQL query does.

SELECT *
FROM locations
INNER JOIN persons ON location.person_id=persons.person_id
ORDER BY location.name, person.name
--
http://home.mysth.be/~timvw

[Dennis Biletsky]

"R.G. Vervoort" <ro**********@royvervoort.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:40*********************@news.xs4all.nl...

Does anyone have a suggestion how I can order a list with names in a
secondary select string.

The first string selects a number of locations where people work

From this string I get several id's form people (in the location table there are no names but id's form the people table) that work on those locations

No I make another select to get the name form the people table using the id I got before.

I would like to have the table ordered alphabetical by the name of the
people

Since the number op people is very long is will be to slow working the other way around (first selecting people and then looking for the location)

Example:

Location 1 Name A

Name B

Name C

Location 3 Name D

Name E

Location 5 Name F

Location 2 Name G

Location 9 Name H

Location 7 Name I

ORDER BY name ASC

[R.G. Vervoort]

it are different table and the first table does not contain names, onlu the
id form names.

Ordering ASC woll not work because it is not in the first query

thank for thinking with me anyway
"Dennis Biletsky" <uf***@ua.fm> schreef in bericht
news:c7***********@fortress.intercom.net.ua...

"R.G. Vervoort" <ro**********@royvervoort.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:40*********************@news.xs4all.nl...

Does anyone have a suggestion how I can order a list with names in a
secondary select string.

The first string selects a number of locations where people work

From this string I get several id's form people (in the location table

there

are no names but id's form the people table) that work on those locations
No I make another select to get the name form the people table using the

id

I got before.

I would like to have the table ordered alphabetical by the name of the
people

Since the number op people is very long is will be to slow working the

other

way around (first selecting people and then looking for the location)

Example:

Location 1 Name A

Name B

Name C

Location 3 Name D

Name E

Location 5 Name F

Location 2 Name G

Location 9 Name H

Location 7 Name I

ORDER BY name ASC

[Joe Parish]

Can you combine the queries?

Take the following example, given that there is a table post and there is a
table sprite. The post table contains several fields including a SPRITEID
field whos value corresponds directly the unique identifier of the same name
(SPRITEID) in the sprite table. The sprite table also contains a SPRITENAME
field that corresponds to the relative path of an image file.

Select post.POSTID, post.SPRITEID, sprite.SPRITENAME, sprite.SPRITEID
from post, sprite where post.SPRITEID = sprite.SPRITEID order by
sprite.SPRITENAME desc;

I have this table here and these are the first few results:

'post.POSTID',' post.SPRITEID', 'sprite.SPRITENAME',
'sprite.SPRITEID'
'245', '21', '"..\..\graphical
dump\esd\wizardjames.gif"', '21'
'252', '21', '"..\..\graphical
dump\esd\wizardjames.gif"', '21'
'188', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'216', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'220', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'228', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'232', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'233', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'238', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'242', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'243', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'248', '13', '"..\..\graphical
dump\esd\trevor.gif"', '13'
'183', '10', '"..\..\graphical
dump\esd\stew.gif"', '10'
'202', '10', '"..\..\graphical
dump\esd\stew.gif"', '10'
'208', '10', '"..\..\graphical
dump\esd\stew.gif"', '10'
'213', '10', '"..\..\graphical
dump\esd\stew.gif"', '10'

If you really want, look at the attatched txt file to see the full
results.

This is from a silly news poster/CMS type thing I wrote called ESDNews

I hope that helps you to work it out, if I'm understanding the question
correctly.

Joe Parish
"R.G. Vervoort" <ro**********@royvervoort.nl> wrote in message
news:40*********************@news.xs4all.nl...

it are different table and the first table does not contain names, onlu the id form names.

Ordering ASC woll not work because it is not in the first query

thank for thinking with me anyway
"Dennis Biletsky" <uf***@ua.fm> schreef in bericht
news:c7***********@fortress.intercom.net.ua...

"R.G. Vervoort" <ro**********@royvervoort.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ

ÓÌÅÄÕÀÝÅÅ: news:40*********************@news.xs4all.nl...

Does anyone have a suggestion how I can order a list with names in a
secondary select string.

The first string selects a number of locations where people work

From this string I get several id's form people (in the location table

there

are no names but id's form the people table) that work on those locations
No I make another select to get the name form the people table using

the id

I got before.

I would like to have the table ordered alphabetical by the name of the
people

Since the number op people is very long is will be to slow working the

other

way around (first selecting people and then looking for the location)

Example:

Location 1 Name A

Name B

Name C

Location 3 Name D

Name E

Location 5 Name F

Location 2 Name G

Location 9 Name H

Location 7 Name I

ORDER BY name ASC