join problem

[poring]

I have two table: (simplifyed)

• 'tabone' has the following columns: 'id' and 'hello'
• 'tabtwo' has the following columns: 'id' and 'hi'

I have this query:

SELECT tabone.hello, tabtwo.hi
FROM tabone, tabtwo
WHERE tabone.id = 5 AND tabtwo.id = 5

Now that works fine if there is and 'id' wich has the value 5 in both table, but the problem is that if tabtwo doesn't have any row with 5 in the id column, the query won't return anything at all. (when I want it to return the row in tabone wich does have 5 in the id column)

Is there any way to do this, or will I have to make two separate queries? Thanks.

[notionlogic]

In order to get the join correctly, the query should actually say something like this:

SELECT tabone.hello, tabtwo.hi
FROM tabone, tabtwo
WHERE tabone.id = 5 AND tabone.id = tabtwo.id

Hope this helps

[poring]

I think that's completely equal to my query above.. but thanks anyway.

[notionlogic]

My mistake, I didn't read your post properly...

I think what you're looking for is the LEFT JOIN syntax although I can't remember it off the top of my head

Something like:

SELECT tabone.hello, tabtwo.hi
FROM tabone LEFT JOIN tabtwo on tabone.id = tabtwo.id
where taboneid = 5

Is that any better?

[poring]

That works exactly like I wanted it to! Thanks a lot!