On Wednesday 26 July 2006 10:31 am, Peter Lauri wrote:
Best group member,
I just made up this query, but let us work from this:
SELECT * FROM table1
LEFT OUTER JOIN table2 ON (table1.id=table2.id)
WHERE table2.prop IS NULL;
If I understand correct:
SELECT * FROM table 1
WHERE id NOT IN
queries?
/Peter
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 5:37 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 10:31 am, Peter Lauri wrote:
Best group member,
I just made up
On Wednesday 26 July 2006 10:53 am, Peter Lauri wrote:
I tried that, but that generates:
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SELECT id FROM table2)
LIMIT 0, 100' at line 1
What's the
The query in full was exactly as you wrote it (but without the typo) :)
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 5:56 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series here
and that works just fine.
--
Chris White
PHP Programmer/DBackItUp
Interfuel
--
MySQL
, July 27, 2006 6:05 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series
On Wednesday 26 July 2006 11:30 am, Peter Lauri wrote:
4.0.27, so that is probably the reason. Any other way then with a sub
query? I solved it with my stupid solution, feels strange to JOIN tables
and choose rows where the join value is NULL (left outer join) :)
Are you using phpMyAdmin? I
, 2006 6:43 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:30 am, Peter Lauri wrote:
4.0.27, so that is probably the reason. Any other way then with a sub
query? I solved it with my stupid solution, feels strange to JOIN tables
and choose
mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series