[thelist] SQL: How Do I Combine Multiple Rows into One?
Jason Handby
jasonh at pavilion.co.uk
Mon Mar 3 16:45:01 CST 2003
> Forgive me: I was confusing my own example. Table A has no
> primary key,
> period, and no unique ID. Although it is a temporary table.
Oh right. I *was* going to suggest some cunning piece of JOINery (Table A
joined to itself multiple times) which might enable you to do all of this in
one UPDATE statement; but, given that you have no unique ID in Table A, I
don't think that would work...
J
More information about the thelist
mailing list