[thelist] SQL Query help

[CDitty]

A comma?  Gesh.  Thought I looked at all that.  Thanks.  And thanks for the 
AS idea.  Noted and done.  :)

Chris


At 05:56 PM 7/31/2003, you wrote:
>On Thursday 31 July 2003 06:42 pm, CDitty wrote:
> > Does anyone see anything wrong with this query?
>
> > SELECT a.merchantName AS merchantName, b.downloadCost AS cost, b.merchBank,
> > b.merchType, c.filePath AS filePath,
>-------------------------------------^
> > FROM users_t a, merchants_acct b, filepaths_t c
> >
>
>don't have a comma after the last column declaration, 'filepath'.
>
>Also, since this is mySQL, you shouldn't need to use 'AS' there, it will not
>return the table names/aliases along with the column names. ie, you will get
>merchantName   downloadCost   merchBank   merchType   filePath
>even without your AS clauses. Should look a little neater.
>--
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !