>Anyone very had to records in two different tables? In other words, table A is the mother table. Table B has entries from table A as the child. I want to be able to comaper the two tables and give a result if the the record in table B exists in table A.
Use a nested select statement:
SELECT keyfield, field1, field2, FROM tableA;
WHERE keyfield IN (SELECT keyfield from tableB)
This gets fields from a record in Table A which has a field which appears in Table B.
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.