• why no inner join?

    select x.col1, x.col2, y.col3, y.col4

    from TabA as x

    inner join

    TabB as Y

    on x.col11 = y.coll11

    where x.col11 = 'A'