l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Jul 21 10:13

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] SQL help - unions
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] SQL help - unions

On Wed 21 Jul 04,  1:36 AM, David Hummel <dhml@comcast.net> said:
> On Wed, Jul 21, 2004 at 12:00:39AM -0700, Jeff Newmiller wrote:
> > 
> > A headcount is not the same as a roster... neither Peter's nor
> > Michael's version was counting anything.
> I assumed what Peter was after was a list of unique SSN's for "race = 0"
> students in Fall_2003 and Spring_2004.
Unfortunately, I'm being forced to use MS Access at work.  In Access, a
roster always gives you a headcount (but a headcount doesn't necessarily
give you a roster).  So a roster is good too.

Actually, Access is kind of neat, but it has a major drawback.  You can
build fairly complex queries with a graphical interface.  You can also
build them using SQL.  But the GUI is very convenient.  Until you hit
something the GUI can't do, like this.

I've been told the GUI query builder can't accomplish this task because
the database is designed poorly, as Jeff pointed out.  But these are
actually text files written by a mainframe that are sent to the state to
report various things about our college.  They weren't meant to be part
of a database.  That was my idea.  :)

The downside of using Access (other than the obvious) is that you tend
to rely on the GUI interface when you should be concentrating on your
basic SQL skills to prepare yourself for the inevitable time when you
HAVE to use SQL because the GUI can't do it (like now - there's no GUI
for unions).


In theory, theory and practise are the same.  In practise, they aren't.
GPG Instructions: http://www.dirac.org/linux/gpg
GPG Fingerprint: B9F1 6CF3 47C4 7CD8 D33E 70A9 A3B9 1945 67EA 951D
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Sunset Systems
Who graciously hosts our website & mailing lists!