simple sql question

[vocoder]

i have two tables

pro_ab (ab_id, title, text) and pro_fig (fig_id, ab_id, image)

now I need to get a list of all ab_id's that are in pro_ab, but not fig_id. I'm having a brain fart....what is the SQL command I need to do this?

[Lars_Berg]

select pro_ab.ab_id
 from pro_ab left join pro_fig
on pro_ab.ab_id = pro_fig.ab_id
where pro_fig.ab_id is null

[vocoder]

doh! thanks so much