syntax error in SQL Posted April 6, 2019 select A.country,count(A.CustomerID) as N from (select country,Count(CustomerID) as N1 from customers group by country) as A left join (select country,Count(CustomerID) as N2 from customers group by country) as B on A.N1=B.N2 the error:it is not reading A.customerid
syntax error
in SQL
Posted
select A.country,count(A.CustomerID) as N
from
(select country,Count(CustomerID) as N1 from customers group by country) as A
left join
(select country,Count(CustomerID) as N2 from customers group by country) as B
on A.N1=B.N2
the error:it is not reading A.customerid