not sure how to use inner join (was "MySQL Query Help Please...")

[Tapan]

Hello,

Basically i have 2 tables users and listings. In users table there is user's info like username / password etc. and in listings table there are listings of a user..which can be more than 1.

Currently I was just getting results by just searching the listings table by a simple query like: "SELECT * FROM listings WHERE title = 'abc'"; but now what I want do is that I can search for some fields in user table also.

For eg. currently listings are displayed..but now i should be able to see all listings by searching username of post code. So please tell me how do i go about it ? I know that it can be done using INNER JOIN but i am not sure how to use it.

Please help.

Thank you.

[r937]

select u.name
     , u.postcode
     , l.title
  from users as u
inner
  join listings as l
    on l.userid = u.id
 where u.postcode like '%CP3%'
    or l.title like '%fanciful%'