when table is published in metastore (target option in the pipeline) for Python I just used spark.read.table() with join of dlt table, so I bet in SQL it would be something like:

FROM STREAM(LIVE.branch_bronze) b
INNER JOIN TARGET_DB.charter c