"Chris" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Mike Sullivan wrote:
>> Hi all thanks for the responses! What I have is a 6 table db that has
>> each
>>
>> table created from the output of 6 identical laboratory machines (chico,
>>
>> harpo, ...). The out put is a text file
Mike Sullivan wrote:
Hi all thanks for the responses! What I have is a 6 table db that has each
table created from the output of 6 identical laboratory machines (chico,
harpo, ...). The out put is a text file which I import as a table named
after the machine. I do realize that one solution is
Hi all thanks for the responses! What I have is a 6 table db that has each
table created from the output of 6 identical laboratory machines (chico,
harpo, ...). The out put is a text file which I import as a table named
after the machine. I do realize that one solution is to add the machine
Hi all thanks for the responses! What I have is a 6 table db that has each
table created from the output of 6 identical laboratory machines (chico,
harpo, ...). The out put is a text file which I import as a table named
after the machine. I do realize that one solution is to add the machine
nam
harset=UTF-8
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DB] Building WHERE SQL clauses
You probably want something like this:
SELECT * FROM chico as c, harpo as h WHERE c.operator = "Bill" OR c.operator =
"Jessica" OR h.operator = "Bill" OR h.operator ="Jess
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:
On Mon, Sep 15, 2008 at 1:33 PM, Stephen Wellington <
[EMAIL PROTECTED]> wrote:
> You probably want something like this:
>
> SELECT * FROM chico as c, harpo as h WHERE c.operator = "Bill" OR
> c.operator =
> "Jessica" OR h.operator = "Bill" OR h.operator ="Jessica"
>
> However if those tables real
You probably want something like this:
SELECT * FROM chico as c, harpo as h WHERE c.operator = "Bill" OR c.operator =
"Jessica" OR h.operator = "Bill" OR h.operator ="Jessica"
However if those tables really are identical I would suggest having a
good look at your
database design to see if it can
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 '
