• so if I change the join to cross join and take off 1=1, it will be the same, correct?

    But I read somewhere if a cross join have a where clause, it is the same as inner join,

    is it true for this case?

    Thanks