Oh. Yeah. Joins. Right. Self Joins. I've done joins, this just didn't occur
to me. Thanks for the tip. I'll try it out.
j- k-
On Friday 27 February 2004 07:55 am, Eric B. wrote:
> Not sure how you determine what the order of your rows are, but assuming
> you have a column called rown
Joshua J. Kugler wrote:
1) This is mostly an SQL question, although MySQL may have some trick up its
sleeve that would help me.
2) I've searched the archives, and google
3) I've been using SQL for a long time, but can't think of a way to solve this
4) This may not be possible. :)
I am dealing wit
If you use php to access your data through web pages you can move the
pointer in the query results around. I've got some code I could show you
if it would be helpful. Email me off list.
bob
At 10:55 AM 2/27/2004, Eric B. wrote:
Not sure how you determine what the order of your rows are, but
Not sure how you determine what the order of your rows are, but assuming you
have a column called rownumber, or soemthing to that extent, which is a
sequential numbering of the rows in your table, you can probably do it with
a join on itself. You might have to play with the join syntax a little (i
1) This is mostly an SQL question, although MySQL may have some trick up its
sleeve that would help me.
2) I've searched the archives, and google
3) I've been using SQL for a long time, but can't think of a way to solve this
4) This may not be possible. :)
I am dealing with serial data that is be
