Recreating a query using INNER JOIN? [duplicate]

from field_data_field_date_and_time fdt
JOIN node on fdt.<field> = node.uid

Without seeing your schema, it is hard to tell what the FK is here.