access query

[Fidianto]

Hello everyone,
i got a problem with query, i have 2 table, a with 80 record, and b with 100 record, this two table is connected with employee number, i try to select the 20 record from table b that have no connection with table a, my friend told me to use this sql(from postgresql) but i cannot find the similar query in access --->
select nip from pegawai where nip not in (select nip from jabatan_fungsional);, can someone help me.....

 

[Golom]

Assuming that your table and field names are the ones in the SQL, that should work in Access. The customary way of doing this however is:
[blue][tt]
Select b.*

From b LEFT JOIN a ON b.EmployeeID = a.EmployeeID

Where a.EmployeeID IS NULL
[/tt][/blue]