Re: Need help forming a query
Date: Thu, 18 Nov 1999 16:31:14 GMT
Message-ID: <8119kj$uuf$1_at_nnrp1.deja.com>
Jim,
This appears to be a simple join
select xxx,x,x,x,x,x,x
from
Switchinfo a,
counts b
where include = 'Y'
and a.name = b.switchid;
Just a note about consistency... it is always
good when you can be consistent in naming....
For example: what kind of data is name / switchid?
Is it name?, switchname, switchid, etc...what is
its purpose... Then, name all columns everywhere
consistently.
(Sometimes you can't, either there is more than
one kind of the same ID in the same table, as with
Create_userid, last_userid, etc.
or, the database was inherited from the past, and
the amount of work to standardize is sooooo huge
it cannot be justified just for the sake of theory...)
Good Luck
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 18 1999 - 17:31:14 CET