I need to do a SELECT query from a table but only return the results that equal an 'I' in a column from another table?
How is this done? 

Something like this but I know my syntax is all wrong: 

```
SELECT * FROM table1 
WHERE ITEM_TYPE = 'I' ON table2

```