Quote:
Originally posted by magua
Add other filters (fj.effect_id = 1, etc) at the end. No GROUP BY should be necessary, if I'm reading what you want right.
Note also that those are most likely inner joins, so if there's no matching data in one of the tables, you won't get any rows back. Can't recall the syntax for a left join in MySQL.
|
Gratsi 
This doesn't do exactly what I was looking for, but I think that I am just trying to cram too much into one select -- I'll use your query and then do a little data massaging with PHP. Thanks again.
__________________
seretogis - sieg heil
perfect little dream the kind that hurts the most, forgot how it feels well almost
no one to blame always the same, open my eyes wake up in flames
|