[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).

  Damien COLA

-----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,


* * Please support the community that supports you.  * *

Evolt.org conference in London, July 25-27 2003.  Register today at

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