select from mutiple tables

Anon

Hey there.

I need to write an sql statment which will select data from 2 tables. Here's what i have.

SELECT t1.title, t1.body, t2.cname FROM $db_tbl_announce as t1, $db_tbl_class as t2 WHERE t1.cid = t2.cid ORDER BY t1.aid DESC

This statment will select data from the $db_tbl_announce table where the cid collum is equal to the cid collum in the $db_tbl_class table.

Here's the catch though. cid in $db_tbl_announce can be NULL. If it comes up against a null value, i want it to be selected. Can anyone help?

Thanks in advance.

Anon

This is only a guess, but you can try this. I don't know if this will work, but you can go for it.

SELECT t1.title, t1.body, t2.cname FROM $db_tbl_announce as t1, $db_tbl_class as t2 WHERE ( t1.cid = t2.cid ) OR ( t1.cid IS NULL AND t2.cid IS NOT NULL) ORDER BY t1.aid DESC

This probably won't work too well, but you can still go for it. The problem is that there won't be the needed matching value between the two tables, I think.

RCM

Anon

I think you want to do an outer join. Something on the order of:

select t1.title, t1.body, t2.cname from $db_tbl_announce as t1 right outer join $db_tbl_class as t2 where t1.cid = t2.cid ...

I'm not sure that the syntax is right, but I'm pretty sure the outer join is the way to go. For me, they usually take a lot of fooling with to get right.

Mike