Hi all,
I have two tables, one is a log table and another is a repository table. I would like to process all rows from the repository table that do not have an entry in the log table AND process anything that has a N is the moved_to_audit field (of the log table).
I was able to create the unmatched query, which returns everything not in the log table, but I am unsure how to add rows that are in the log table (but have a N flag set for moved_to_audit).
Code:
SELECT tracking_repository.id, tracking_repository.client_code, tracking_repository.carrier_code, tracking_repository.mode, tracking_repository.account_number, tracking_repository.bill_type, tracking_repository.invoice_number, tracking_repository.invoice_date, tracking_repository.net_charges, tracking_repository.tracking_number, tracking_repository.sender_company_name, tracking_repository.sender_name, tracking_repository.sender_address_1, tracking_repository.sender_address_2, tracking_repository.sender_city, tracking_repository.sender_state, tracking_repository.sender_postal, tracking_repository.sender_country, tracking_repository.receiver_company_name, tracking_repository.receiver_name, tracking_repository.receiver_address_1, tracking_repository.receiver_address_2, tracking_repository.receiver_city, tracking_repository.receiver_state, tracking_repository.receiver_postal, tracking_repository.receiver_country, tracking_repository.ship_date, tracking_repository.service, tracking_repository.tracking_service_code, tracking_repository.saturday_delivery, tracking_repository.additional_handling_weight, tracking_repository.additional_handling_size, tracking_repository.additional_handling_longest_side, tracking_repository.residential, tracking_repository.zone_code, tracking_repository.package_type, tracking_repository.ship_weight, tracking_repository.bill_weight
FROM tracking_repository LEFT JOIN tracking_log ON tracking_repository.[id] = tracking_log.[tracking_repository_id]
WHERE (((tracking_log.tracking_repository_id) Is Null));
Hopefully I did a good job of explaining that.
Thanks