mysql: how to connect 2 tables

hi there,

i have two table with table name A, B

table A: id, content
tableB: A_id, contenting

:: tableA.id = tableB.A_id

i want to create one sql statement to pick up the content in tableA EXCLUDING those have the contenting="something"

I try using
select tableA.content from tableA, tableB where tableA.id!=(select tableB.A_id from tableB where contenting='something')

eg.
i use table A for all my subscription list
and table B for those who have subscribed with subscribed_id, member_id

i want to check this member's unscribed list item

Try this:

Select tableA.Content From tableA Inner Join tableB On tableA.id=tableB.A_id Where tableB.Contenting<>'something'

I have sorted it out by using left join .. on .. as well

thanks anyway