[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