Example: Join a Local Table with a Remote Table. - Teradata Fabric

This query:

• Combines customer data from a local Teradata table with vehicle data from a remote table
• Returns the customer ID, vehicle make, and vehicle model for matching CarID values.

SELECT c.CustomerID,
       p.make,
       p.model
FROM customer c
JOIN teradata1.default.cardata p
  ON c.CarID = p.CarID;