I have two tables A and B in a 1:1 relationship. Table A has many records, Table B a few, and the tables share a key unique index field "kindex". That is, any record in B corresponds to a record in A having the same value of kindex, but most records in A have no corresponding record in B.
How do I write a query that selects all records in Table A that do NOT have a corresponding record in Table B? In other words, "B" is a list of "A" records EXCLUDED from the query.