[thelist] SQL Query help

CDitty mail at redhotsweeps.com
Thu Jul 31 17:42:08 CDT 2003


Does anyone see anything wrong with this query?   I'm trying to make it as 
flexible as possible.  It works if I drop the filepath table.

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
WHERE a.user_id =  'user' AND
a.user_password =  'password' AND
b.merchActive =  '1' AND
a.merchantName = b.merchantName AND
b.merchantName = c.merchantName

This is the error that I am getting.  You have an error in your SQL syntax 
near 'FROM users_t a, merchants_acct b, filepaths_t c WHERE a.user_id 
=  'eastwood' AN' at line 2

Thanks
Chris



More information about the thelist mailing list