|
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=110102
) 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=110099
) 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=106581
) as subquery
Public Service Alliance of Canada
This union represents 150,000 workers across Canada and abroad. They do jobs like issue pension and EI cheques, forecast the weather, operate airports and inspect meat plants. Newer members work in places like women's shelters, casinos and universities.
Main Address
233 Gilmour Street
Ottawa, Ontario
K2P 0P1
Main Telephone
613-560-4200
Joined OneWorld
28.11.2001
Features
26.04.2005
Réunis en assemblée générale le 15 avril, les membres du Syndicat des étudiantes et étudiants employés de l'Université du Québec à Montréal (UQAM), affilié à la FTQ, ont accepté avec enthousiasme leur première convention collective, conclue après quatre mois de négociations intensives. Ce syndicat de 2 000 membres regroupe les assistants d'enseignement et de recherche. Premier du genre au Québec, il est rattaché à l'Alliance de la fonction publique du Canada (AFPC).
Story link
25.04.2005
It's time to pay your taxes again. Just don't trying paying them at the Canada Revenue Agency (CRA). By this time next year, the CRA will have closed its cash counters. "In spite of the Revenue Agency's motto - More Ways to Serve You! - CRA is doing just the opposite by closing its cash and client service counters as part of the Liberal government's expenditure review exercise," says Union of Taxation Employees (UTE) National President Betty Bannon.
Story link
Related topics/regions:
[Canada]
09.03.2005
La Journée internationale des femmes marque près d’un siècle de lutte pour l’accès des femmes à l’égalité. En ce 8 mars 2005, les femmes de l’AFPC ne se contenteront pas de célébrer. Elles vont aussi participer à une campagne qui aura une incidence sur la vie des femmes d’un bout à l’autre du pays.
Story link
|
|
|
|
