Need help to form query

[zzz]

I have 2 tables.

t1 has the following cells:

t1. event
t1.zipcode

t2 has the following:

t2.zipcode
t2.city
t2.state

I already have a zipcode given, let's say t1.zipcode = '12345' how do I count how many events in that city?

I was trying something like this:

SELECT count(t1. event)
FROM t1
LEFT JOIN t2 ON (t1.zipcode = t2.zipcode)
WHERE ... // and that's where I'm stuck...

[zzz]

I think I might be able to figure it out now. I was able to get City before the query...

[zzz]

... or not... still need help.

[ahundiak]

select count(t1.event)
from t1
inner join t2 on t1.zipcode = t2.zipcode
where t2.city = 'Huntsville';

[zzz]

Great.

I decide to scrap the idea. Although it was a useful feature but it slows the page load dramatically because there are tens of thousans of rows in t2. I'll just hardwire it and take mychances.

Questions about INNER vs LEFT JOIN... I mainly use LEFT JOIN, not sure why I do but I do. Which one is faster?