Good morning! all beauty On the site I'm moving, it displays a list of countries that come from the database. However, there was a requirement that OFAC-sanctioned countries should not be exhibited.
It calls countries with the following SQL commands:
var sql = @"
SELECT
id, nome_pt AS nome
FROM loc_pais
ORDER BY nome_pt
";
My doubt is; "can I put a filter to not display those countries that are sanctioned, or would it be better to exclude them from the table?"