how about type like this
SELECT * FROM chico c, harpo h WHERE c.operator = "Bill" OR c.operator =
"Jessica"
Mike Sullivan wrote:
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 =
"Jessica"
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
