Do you have a question? Post it now! No Registration Necessary. Now with pictures!
August 15, 2005, 7:07 am
rate this thread
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 a.name, 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
- » ERROR:Using the mysql client on freebsd to restore a mysqldump??
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum