[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...


More information about the thelist mailing list