|
select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=103803
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=102609
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=99174
) as subquery
National Union of Public and General Employees
This family of 14 component unions is Canada's second largest national union. Most of its 325,000 members deliver public services to the citizens of their home provinces. NUPGE advocates for progressive labour law, social programs and public services.
Main Address
15 Auriga Drive
Ottawa, Ontario
K2E 1B7
Main Telephone
613-228-9800
Joined OneWorld
06.03.2002
Features
24.02.2005
Liberal MPs, hoping to retain their grip on power, or save their seats if an election is forced upon them, applauded giddily when Finance Minister Ralph Goodale tabled the eighth straight black ink budget, an achievement he described as "the longest unbroken string of surpluses since Confederation." The big winners are the military, corporations, seniors and Canadians with the money to sock away in Registered Retirement Savings Plans (RRSPs).
Story link
Related topics/regions:
[Canada]
03.02.2005
A new public opinion poll conducted on behalf of the National Union of Public and General Employees (NUPGE) indicates that a federally-paid national child care program is popular across the country. “Results showed that three quarters of Canadians are ready to have Ottawa pay the price for a national child care program,” says NUPGE national president James Clancy.
Story link
Related topics/regions:
[Canada]
07.12.2004
Canada has been caught in the glare of an international security fiasco by the disclosure that 1,127 airport security uniforms, or parts of them, and nearly 100 airport security badges, have been lost, apparently by one or more of the private firms contracted to screen Canadian air passengers.
Story link
Related topics/regions:
[Canada]
|
|
|
|
