2011/06/07 17:06 +0200, joe j
WHERE (`person_name` ='Tom' AND `person_name` ='Kevin' )
This is quite wrong: it is always false. Try another operator.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?u
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE (t2.`person_n
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto wrote:
> Why not GROUP BY?
>
>
>
> On Jun 7, 2011, at 10:06 PM, joe j wrote:
>
>> Dear all,
>>
>> I wish to create a new table from a table that has  two columns
>> "country" and "pers
Why not GROUP BY?
On Jun 7, 2011, at 10:06 PM, joe j wrote:
> Dear all,
>
> I wish to create a new table from a table that has two columns
> "country" and "person_name". Thus from the table below, I'd like to
> select all the records of those countries that have person names 'Tom'
> and 'Kevi
"Kate Porter" <[EMAIL PROTECTED]> wrote:
> I am using 4.0.15 on RedHat 7.3 and ran it to a strangest problem today.
>
> SELECT col FROM table WHERE site_id=123;
> returns a list of data.
>
> SELECT col FROM table WHERE site_id IN(123);
> returns an empty set.
>
> Upon further investigation, I f
