I am the VP of Sales at screen-scraper in Provo, Utah.

Dec
28
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Jun
22
awarded Commentator
Jun
22
comment MySQL multiple join, multiple sort maintain group
I'm sorry, I messed up in the sample data of the transaction which I had posted originally. I have now replaced the transaction with this: link. So, yes, Kimberly Krook and Officer Law are the same person, however, they are entered in more than once because they are both party to two separate suits. I corrected the sample data now to reflect the proper case numbers.
Jun
22
revised MySQL multiple join, multiple sort maintain group
deleted 8325 characters in body
Jun
22
comment MySQL multiple join, multiple sort maintain group
I think you're referring to my GROUP BY (I edited your post). I tried what you suggested and it does group by the secondary and tertiary clause. I'm looking to sort the output, say, alphabetically or numerically by given fields. So, although, they are being grouped properly, the output is not sequential. Thank you for your point regarding sp.party_id being unnecessary.
Jun
22
awarded Student
Jun
22
awarded Editor
Jun
22
revised MySQL multiple join, multiple sort maintain group
Added SQL Transaction for use in creating tables and sample data.
1 2 3