I have a main table and a lookup table and I want the lookup table to provide the desc to the codes in the main table using SQL.

My lookup table fields are lk_type,lk_code,lk_desc, and in the SQL I only want it to join to the lookup tables where lk_type = "AL".

My SQL so far:

SELECT table.*,lookup.lk_desc;
FROM table LEFT OUTER JOIN lookup ON;
lookup.lk_code = table.lk_code

What can I do next to ensure that only the lk_types of "AL" are matched?

Thanks
Kev