Hello all.  I'm using PHP to build a query for a database that consists of 
multiple tables, all with identical attribues.  A typical syntax try looks 
like this:  SELECT * FROM chico, harpo WHERE operator = "Bill" OR operator = 

MySQL responds with this:  Couldn't execute query.Column 'operator' in where 
clause is ambiguous

I was hoping that since the tables are identical all I would need to do is 
list the attribute values not have to append them to the table names.  Is 
there any way to do this?  Perhaps with a setting in MySQL or a different 
syntax (JOIN, UNION, ...)?  If not are there available some canned code 
snippets that build these types of strings from values passed in the $_POST 
array.  Thanks for any insights on this. --- Mike 

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to