Since you cannot issue a DELETE directly from the Legal database against the accesslogs table in the Records database (because external tables are read-only), the recommended solution is:

1. Prepare the list of accessID to delete in Legal database using external tables.
2. Export this list to a staging table in the Records database.
3. Use a stored procedure in the Records database to perform the deletion.
4. Trigger the procedure using an orchestrator such as Azure Data Factory, Synapse Pipeline, or a scheduled job.

So, let's start by creating External tables in Legal database:

CREATE EXTERNAL TABLE AccessDB_accessinfo
(
    employeeID INT,
    tokenID INT,
    ...
)
WITH (DATA_SOURCE = [AccessDBDataSource], SCHEMA_NAME = 'dbo', OBJECT_NAME = 'accessinfo');

CREATE EXTERNAL TABLE RecordsDB_accesslogs
(
    accessID INT,
    tokenID INT,
    accessPoint NVARCHAR(100),
    dateAndTime DATETIME,
    ...
)
WITH (DATA_SOURCE = [RecordsDBDataSource], SCHEMA_NAME = 'dbo', OBJECT_NAME = 'accesslogs');

After this, prepare the list of accessIDs to Delete in the Legal Database (Replace this with your specific logic). From the Legal database, use a T-SQL query to join the data and filter by employeeID:

SELECT al.accessID
INTO #userrecords
FROM RecordsDB_accesslogs al
JOIN AccessDB_accessinfo ai ON al.tokenID = ai.tokenID
JOIN dbo.personalinfo pi ON ai.employeeID = pi.employeeID
WHERE pi.employeeID = @targetEmployeeID; 

Now, Export accessIDs from Legal to a staging table in Records:

Since external tables are read-only, the Legal database cannot write directly to the Records database. To bridge this, let's Create a staging table in Records database:

CREATE TABLE dbo.to_be_deleted_accesslogs (
    accessID INT PRIMARY KEY
);

Then create a Synapse pipeline/ Azure Data Factory/SQL job that:

• Connects to the Legal database.
• Inserts the results into Records.dbo.to_be_deleted_accesslogs.

Lastly, Call a stored procedure in Records DB to delete from accesslogs:

CREATE PROCEDURE dbo.DeleteOldAccessLogs
AS
BEGIN
    DELETE FROM dbo.accesslogs
    WHERE accessID IN (SELECT accessID FROM dbo.to_be_deleted_accesslogs);
END;

Now Trigger the procedure via:

• A scheduled PowerShell script
• Azure Data Factory or Synapse pipeline