Joe Martinez wrote:

>> Select sales.*, customers.custfname, customers.custlname
>> from sales, customers
>> where ...

> wow. I really didn't know you could do it! Thanks for the syntax.

You can, but you really shouldn't. If some one adds a field to sales,
or drops one, or changed the field order in the table, your query is
going to mess up. One of the sadder parts of the history of relational
databases is that a loosey-goosey interactive query language was chosen
as the standard for program access. The "*" syntax should never be used
outside casual, hand-typed, one time queries.


Regards,


Ann