0 - 2 of 2 tags for inner join

q) Use COUNT and DISTINCT to determine how many distinct skus there are in the skuinfo, skstinfo, and trnsact tables. Which skus are common to all tables, or unique to specific tables?

Hi All,

Please help me through this

sel

a.col1,

a.co2,

a.col3,.........b.col1,b.col2..,c.col1,c.col2

from table1 as a inner join table2 as b on a.col1 =b.col1

inner join table 3 as c on a.col1 = b.col1

where col1 = xxxxx;