Newbee Subselect question

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have previously worked mostly with Sql Server and wonder how to write
a subselect query in mysql 4.0. What i would like to do is something

select, b.isbn
from author a
left outer join isbn b on b.authorid in(select id from author)

When trying to running the query i get a syntax error near (select id
from author). How do i write a subquery like "in (select id from
author)"? Please ignore the rest of the query, it's just a poor example



Re: Newbee Subselect question

Magnus wrote:

Quoted text here. Click to load it

Subselects are supported from version 4.1, which means that you can't
write them with MySQL 4.0 at all (you can instead use joins in most cases).

Site Timeline