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
, 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 J
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?
: Thursday, 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
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 Gener
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 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
upport sub 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,
>
>
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
