SELECT a.ClientID, a.Name, a.Addr, a.City, a.Prov, a.PC, b.Name, a.Phone, a.Email
FROM T_Client a, T_Country b
WHERE a.CountryID = b.CountryID
ORDER BY a.Name