(no subject)

[scottobear]

Scotto, don't forget.

SELECT rpr0324.NAME, rpr0324.OFFICE, rpr0324.SEQ, rpr0324.PREFIX, Count(rpr0324.PREFIX) AS CountOfPREFIX
FROM rpr0324
GROUP BY rpr0324.NAME, rpr0324.OFFICE, rpr0324.SEQ, rpr0324.PREFIX
HAVING (((rpr0324.NAME)="Jennifer Poole"));


simplicity is what matters. Jenny will be much happier, as a result.

Comments

dude...

[childhood.livejournal.com]

why are you re-specifying the table name with the field you're referencing in query? you only need to do that when there's two tables with the same fieldnames..

:)~

Re: dude...

[scottobear.livejournal.com]

there are, that's a smaller chunk of fat code.

oh so it's partial sql code

[childhood.livejournal.com]

i.e. a sub select? still sure you shouldn't need to reference it so explictly..

but heck i'm only seeing a small portion of this program. i'm not messing with you bad ass developer types ;) *chuckles*

p.s. how did the newt live test go? was it as cool as the simulation? :)

Re: oh so it's partial sql code

[scottobear.livejournal.com]

I always am explicit in my code, just so we know exactly what we're looking at... who knows what table we're referencing a year from now.

no, it's part of a module that'll be plugged into some assorted other codes. :)

Newt's far better in real life than in the simulator.

Re: oh so it's partial sql code

[ckirkman.livejournal.com]

Um, Chris lost. Chris not mean what you say. Me go paint on cave wall now.

Re: oh so it's partial sql code

[scottobear.livejournal.com]

Ug, after today at work, Mongo am with you.