how to get the condition in join query

[Opperessor]

this is the query
select b.tab1 as id,b.ref_id as reference_id, count(e.application_user) as user_map,source as cluster_name from product.database_table b left join product.database_table_access e on b.tab1 = e.tab1 group by b.tab1,b.ref_id,source

need only this b.tab1 = e.tab1
did try this
for table in parse_one(r).find_all(exp.Join):
print(table)
im able to get this-
left join product.database_table_access e on b.tab1 = e.tab1 group by b.tab1,b.ref_id,source is it possible to just extract b.tab1 = e.tab1

[georgesittas]

How about the following?

>>> for eq in parse_one(<your sql>).find_all(exp.EQ):
...    print(eq)
...
b.tab1 = e.tab1

[Opperessor]

tx