Search:

Ah, of course, I didn't spot the "order" ambiguancy.
The query seems to work, thanks sooooo much!

Thanks for your suggestion!

However, I get a syntax error on the "from order t1" part - are you sure that's correct?

You have an error in your SQL syntax; check the manual that corresponds to...

I have a table 'order' with the following columns:


id | name | status | year

For simplicity, let's say the table contains people who attended an annual event. The 'status' column is '1' if...