Sql Statement error..

[Anon]

"SELECT * FROM BT,nash where active = '1' ORDER BY RAND() LIMIT 1"

I"m trying to use this statement but I get the following error.

Column: 'active' in where clause is ambiguous
and mysql also says

You have an error in your SQL syntax near '"SELECT * FROM BT, nash where active = '1' ORDER BY RAND() LIMIT 1"' at line 1

Both tables have the active field.

I know it's something small.. any ideas?

[tcarter]

fully qualify the active column in the where clause
Example: "SELECT * FROM BT,nash where BT.active = '1' ORDER BY RAND() LIMIT 1"

[Anon]

Not sure if i'm doing this right then because it doesn't seem to be workign right.
I want a random row from either the nash or the BT database where that row has active = 1.

"SELECT * FROM BT,nash where BT.active = '1' ORDER BY RAND() LIMIT 1"

seems to only grab random rows from the nash database. If i do this

"SELECT * FROM BT,nash where nash.active = '1' AND BT.active = '1' ORDER BY RAND() LIMIT 1"

OR

"SELECT * FROM BT,nash where nash.active = '1' OR BT.active = '1' ORDER BY RAND() LIMIT 1"

they both only seem to grab pics for the nash database and not the BT one.

[Anon]

try not using the single quotes around the 1
eg "select * from BT, nash where BT.active = 1 or nash.active = 1 order by rand limit 1"

sometimes I find when asking for a number field, sql statements do not like quotes around the number
The Professional SQL Server programming book never puts quotes around numbers