One to None ????
Okay, relational tables is easy. If two tables are related, by say a SerialNumber field, I want to see what records in table A have no relations in table B and delete those records in table A. How do I do that?
We have an instrument table that has 42,000+ instrument records. I bet a lot of those do not have associated work orders (another table) for them. In fact I just trimmed out work order records older than 7 years. I would like to trim out instruments that are no longer active if they no longer have a work order record associated with them.
This is kind of the oposite of a select query where I have two table and relate them with the serial number field. I want to see only the instrument records that have no relationship. If that makes any sence.
Thanks!
Okay, relational tables is easy. If two tables are related, by say a SerialNumber field, I want to see what records in table A have no relations in table B and delete those records in table A. How do I do that?
We have an instrument table that has 42,000+ instrument records. I bet a lot of those do not have associated work orders (another table) for them. In fact I just trimmed out work order records older than 7 years. I would like to trim out instruments that are no longer active if they no longer have a work order record associated with them.
This is kind of the oposite of a select query where I have two table and relate them with the serial number field. I want to see only the instrument records that have no relationship. If that makes any sence.
Thanks!
Last edited:
