Re: same-table join

2005-05-11 Thread Michael Stassen
Mike Johnson wrote: I think I'm just having a brain fart here, but if someone could help me out I'd appreciate. Maybe it's just too late in the day for thinking... Say I have a table `actions` with a structure and data as such: ++++ | id | userid | action | +++--

same-table join

2005-05-11 Thread Mike Johnson
I think I'm just having a brain fart here, but if someone could help me out I'd appreciate. Maybe it's just too late in the day for thinking... Say I have a table `actions` with a structure and data as such: ++++ | id | userid | action | ++++ | 1 | a