WHERE lk_types="AL" should do it.
>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