sql error [Unknown column 'B.country' in 'field list']
sql [select A.id,A.service_title,A.service_desc,A.create_date,A.city,C.name as cname,D.industry_name as iname,A.tags,B.country,A.inquiries,A.email,A.pid FROM ci_services A LEFT JOIN ci_country
B ON A.country = B.Country_Code LEFT JOIN ci_cat C ON A.category = C.id LEFT JOIN
ci_industries D ON A.industry = D.id LEFT JOIN ci_states E ON
A.state = E.State_ID AND A.country = E.Country_Code LEFT JOIN ci_cities F ON A.city = F.City_ID WHERE A.pid = '20' AND A.service_type = 'S' GROUP BY A.id
order by id DESC LIMIT 0,10]
Companiesinfo, Global marketplace for companies information, business and professional networking
