0 - 1 of 1 tags for clause

Hello everyone,

  I have SQL question, about how does having a filter condition like (say) prod_cat = 7980 in the following two conditions will be treated

1. In a where clause of multiple joins

    something like a inner join b

                               on [join cond]