[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