Query join help

[admin]

Hi

I have two tables; 1 contains items, the other is account information of the user who owns the items.

The account information table has userid and account status, which is either active or inactive.

I want a user to be able to search the items table for an item and only return the items which are listed by a user whose account status is active.

I know I will have to use a join but am struggling as to exactly how.

Any ideas? Is this enough information?

Thanks

Darren