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

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.
Jun
22
comment MySQL multiple join, multiple sort maintain group
If I add p.name, c.charge_code after the existing sp.party_id, sp.suit_id then nothing changes. If I add p.name, c.charge_code in place of the existing sp.party_id, sp.suit_id then the suit_id's no longer group properly.
1 2 3