Concord Aquarium is kind of sad =/ Not many good fish, maybe one or two dying softy corals...
All About Fish is awesome for fish really. They got all sorts of cool stuff all the time.
They have a tank full of really neat clams, though they recently put a pair of potters or rusty centrogype in that tank, and I was watching one nip away at one of their beautiful clams! I was like, uh dude, these clams are getting killed.
But the clams they have right now are pretty nice =)
They have a big tank of softies, and a lot of LPS. Most of the softies aren't too colorful, but some ok zoos here and there. The LPS is pretty impressive, lots of euphilia, fungia, and some chalice pieces, etc.
Plus they have a HUGE Erowana in their freshwater area =)