Bill,
If I remember correctly from some other thread, Margo lives across the
street from where I work (CSUS). If she's got a laptop, she can run over
and see me - and at an actual helpdesk!
I wouldn't be able to leave anytime soon or help her after work tonight,
but if she can come over here
Total newbie here. I know less about SQL than I do about xkb. ;-)
I have two tables, with the same structure. Call them [Fall 2003] and
[Spring 2004]. They each hold data about enrolled students. One of the
fields of these tables is SSN (social security number).
I can get an unduplicated
On Tue, Jul 20, 2004 at 04:44:47PM -0700, Peter Jay Salzman wrote:
I can get an unduplicated headcount for the academic year with:
SELECT SSN from [Fall 2003]
UNION
SELECT SSN from [Spring 2004];
There's also a field called race. If the race field is 0, the student
is African
On Tuesday 20 July 2004 05:03 pm, Henry House wrote:
...
A subquery is an easy and fairly intuitive way to do this.
SELECT * from (
SELECT SSN from [Fall 2003]
UNION
SELECT SSN from [Spring 2004]
) WHERE race = 1;
Or to just get the
On Tue, Jul 20, 2004 at 04:44:47PM -0700, Peter Jay Salzman wrote:
Total newbie here. I know less about SQL than I do about xkb. ;-)
I have two tables, with the same structure. Call them [Fall 2003] and
[Spring 2004]. They each hold data about enrolled students. One of the
fields of
On Tue, 20 Jul 2004, Peter Jay Salzman wrote:
Total newbie here. I know less about SQL than I do about xkb. ;-)
I have two tables, with the same structure. Call them [Fall 2003] and
[Spring 2004]. They each hold data about enrolled students. One of the
fields of these tables is SSN
On Tue, Jul 20, 2004 at 06:20:06PM -0700, Jeff Newmiller wrote:
The existence of separate tables with identical structures and disjoint
data in your schema is a red flag to me.
I highly recommend putting all the data into one table with a Season
column to distinguish the rows... it