[thelist] ASP: More Selective Select
Damien COLA
damiencola at wanadoo.fr
Wed Jul 2 21:33:12 CDT 2003
SELECT a.*, b.first_name, b.last_name FROM jobs a, employees b WHERE...
if you want to start somewhere with database : don't use plurial for
your table names. It's part of the concept, it's THE job, THE employee
that you aim to best describe (with your fields).
Cordialement,
Damien COLA
http://www.VarMalin.com
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Casey Crookston
Sent: jeudi 3 juillet 2003 03:21
To: thelist at lists.evolt.org
Subject: [thelist] ASP: More Selective Select
Hello Again,
Okay... I have an SQL statement that begins like this:
SELECT * FROM jobs a, employees b WHERE .......
But here's the thing... I don't want to select * from employees. I DO
want everything from jobs, but from employees I only need first_name and
last_name. No need to clutter a record set with all that data that will
never be used!
What would the syntax be?
Many TIA's,
Casey
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
Evolt.org conference in London, July 25-27 2003. Register today at
http://evolt.org.uk
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list