[thelist] SQL Query help
CDitty
mail at redhotsweeps.com
Thu Jul 31 18:09:23 CDT 2003
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 !
More information about the thelist
mailing list