# Thread: Selecting multiple rows problem

1. Registered User
Join Date
Aug 2004
Posts
1

## Unanswered: Selecting multiple rows problem

Does anybody know how can i solve this problem:

I have something like this:
field1 / field2 / field3 /
--------------------------------------------------
125 / x = avg btwn 125 n 126 / avg btwn x and y /
--------------------------------------------------
126 / x = avg btwn 125 n 126 / avg btwn x and y /
--------------------------------------------------
127 / y = avg btwn 127 n 128 / avg btwn x and y /
--------------------------------------------------
128 / y = avg btwn 127 n 128 / avg btwn x and y /
--------------------------------------------------

maybe i 'll get better explained with this example:

field1 / field2 / field3 /
--------------------------------------------------
125 / / /
----- / x = avg btwn 125 n 126 / /
126 / / /
-------------------------------/ avg btwn x and y / 127 / / /
----- / y = avg btwn 127 n 128 / /
128 / / /
--------------------------------------------------

I have no idea and i need to do this soon or i'm gonna get fired....just kidding

2. Registered User
Join Date
Sep 2001
Location
Vienna
Posts
400

## and what

and what do you want to be the result?

3. Registered User
Join Date
Mar 2004
Posts
110
To be honest.. i have no idea what is in what row and what you want to 'select' from it.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•