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
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;
This selects all rows from table1 where the id is not also in the table2. Is
there any more logic way to do this, this is what
10 matches
Mail list logo
