[thelist] ASP: More Selective Select

Gary McPherson genyus at ingenyus.net
Wed Jul 2 21:41:23 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).

While I would agree with you, there is a school of thought in opposition
to singular naming - arguing that a table represents a collection of
jobs, employees, etc. Each to their own...

More information about the thelist mailing list