I'm Ok with joins could somebody please
explain the IN clause in SQL i.e

Select fields from tables ;
where variable in(select a from b) ;
into cursor temp

Thanks
Rob