Combining two select queries into one ?!?

[SomeDude]

Lo group,

I am wondering if there is a way of combining two SELECT statements into
a single query.

Here's the obligatory example to clarify things:
SELECT id WHERE name=mike
SELECT bills WHERE nameid=12 (12 being the result of the first query)

Right now I am executing two separate calls and I would ofcourse like to
bring that down to a single call.

Any help or pointers would be more than appreciated,

SomeDude.

[Aggro]

SomeDude wrote:

SELECT id WHERE name=mike
This query won't work. Table name is missing from it and value is not
inside '' characters.
SELECT bills WHERE nameid=12 (12 being the result of the first query)

This also is missing the table name.
But perhaps something like this:

select useraccount.id,bill.* from useraccount where name='mike'
left join bill on useraccount.id=bill.nameid;
Please note that the query might not be usable just like that. It
depends on what kind of results you wish to get and since you didn't
even provide working example, it is impossible to tell what you really
expect to get.

[SomeDude]

On Sat, 08 Oct 2005 17:53:40 +0000, Aggro wrote:

SomeDude wrote:

[quoted text muted]

This query won't work. Table name is missing from it and value is not
inside '' characters.

[quoted text muted]

This also is missing the table name.
But perhaps something like this:

select useraccount.id,bill.* from useraccount where name='mike'
left join bill on useraccount.id=bill.nameid;
Please note that the query might not be usable just like that. It
depends on what kind of results you wish to get and since you didn't
even provide working example, it is impossible to tell what you really
expect to get.

Thanks for pointing to LEFT JOIN Aggro, I'll dive into it.

SomeDude

ps: the example was simplified on purpose ;)