Thanks everyone!
I did´nt found this URL at first but when I did everything got clearer ;)
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
Sorry for all the fuzz and RTFM was the answer!
/Anders
Den 01-08-07 17.39, skrev "Sam Masiello" <[EMAIL PROTECTED]>:
>
> You are correct, Tyler.
>
> http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
>
> The above URL has some more information on this.
>
> HTH :)
>
> Sam Masiello
> Software Quality Assurance Engineer
> Synacor
> (716) 853-1362 x289
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 9:58 AM
> To: Anders Alstrin
> Cc: [EMAIL PROTECTED]
> Subject: Re: Sub select.
>
> I don't think MySQL supports sub selects.
>
> Tyler
>
>
> On Tue, 07 Aug 2001 14:57:33 +0200
> Anders Alstrin <[EMAIL PROTECTED]> wrote:
>
>> Does anyone know how to do this sub select in MySQL.
>> I know how to do it in Oracle!
>>
>> table media
>> +----------+-------+----------+
>> | media_id | price |filename |
>> +----------+-------+----------+
>> | 3 | 0 | cal.jpg |
>> | 82 | 0 | Soa.jpg |
>> | 13 | 0 | ca.jpg |
>> | 71 | 0 | gt.pdf |
>> | 67 | 0 | low.pdf |
>> | 68 | 0 | 10.pdf |
>> | 83 | 0 | B5.pdf |
>> +----------+-------+----------+
>>
>> table category_locks
>> +------------------+-------------+----------+
>> | category_lock_id | category_id | media_id |
>> +------------------+-------------+----------+
>> | 92 | 0 | 68 |
>> | 93 | 0 | 67 |
>> | 94 | 0 | 13 |
>> | 91 | 0 | 71 |
>> | 90 | 0 | 3 |
>> | 118 | 43 | 82 |
>> | 121 | 43 | 83 |
>> +------------------+-------------+----------+
>>
>> table categories
>> +-------------+-------------+--------+---------------+--------------+
>> | category_id | category_up | upload | dynamic_media | name |
>> +-------------+-------------+--------+---------------+--------------+
>> | 43 | 0 | false | true | web |
>> | 0 | 0 | false | false | trine |
>> | 0 | 0 | false | false | shop |
>> +-------------+-------------+--------+---------------+--------------+
>>
>> A Oracle way to do it:
>>
>> SELECT * FROM media
>> WHERE media_id = (SELECT media_id FROM category_locks
>> WHERE category_id = (SELECT category_id FROM categories
>> WHERE dynamic_media = 'true'))
>>
>> A MySQL way to do it?
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
>> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
