select kup_ContactInfo.*, kup_Business.*, kup_Areas.* from kup_ContactInfo inner join kup_Business on kup_Business.businessID = kup_ContactInfo.businessID inner join kup_Areas on kup_Areas.areaID = kup_ContactInfo.areaID where kup_ContactInfo.contactTypeID = 3 order by kup_Areas.areaName asc, kup_ContactInfo.contactPerson asc, kup_ContactInfo.businessID asc
Hur får jag in en count() i den här?
Svara
Får felmeddelande om jag bara kör count(*) as antal i select satsen