Hi, All

The following query is very simple:

SELECT COUNTRY_CODE, COUNTRY_NAME FROM COUNTRIES
ORDER BY COUNTRY_NAME

However, I need to add a extra field, DELETABLE, the field which
indicate if the country record has been used/referenced by records in
other tables or not, so to use this field to show a state on the
screen(Grids) visually. I have a lot of SELECT queries which want to do
the same way. Is there any good way and how to fetch it?

Thanks

William