Joining tables

[phpprog]

Hello All
I have two tables (A and B )each with just one field.
Table A is the Parent table and has 100 records (assume)
Table B is the child table with 80 records(assume).
Now can I get the records from table A which are not in Table B.(the remaining 20 records).
anything mysql or Ms-access would be fine..

Please help

Thanks

[phpprog]

Can somebody please help

[Lars_Berg]

select a.* from a left outer join b on a.c1 = b.c1
where b.c1 is null