MySQL query help need. Receiving Error

[centerwork]

Here is the error I am getting:  "Unknown table 'biz_info' in where clause"

 

Here is a copy of the tables in by DB (These are copied and pasted for DB admin):

 

  biz_cont_info

  biz_info

  excluded

  visiter_print_log

 

They are all in the same DB.

 

Here is the query that the error is referring too:

 

$query2 = "SELECT * FROM visiter_print_log WHERE visiter_print_log.winner IS NULL & visiter_print_log.selected IS NULL & visiter_print_log.v_email != biz_info.b_email & visiter_print_log.v_email != excluded.email & visiter_print_log.v_email != biz_cont_info.b_cont_email ORDER BY RAND() LIMIT 1";

$results2 = mysql_query($query2) or die (mysql_error());

 

[centerwork]

The table name is the same as in the DB.  The only thing I can think of is that there is something wrong with how I wrote

 

"& visiter_print_log.v_email != biz_info.b_email"

 

expression.

 

[nloding]

I'm not a SQL command guru at all, but I think it's because you're only selecting from visiter_print_log, not both tables ...

 

You need a join in there I think ... like "SELECT * FROM visiter_print_log AS a JOIN biz_info AS b" or something like that ... Google JOINS.

 

... kind of a not-so-helpful post, but I hope it steers you somewhere!