|
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=104090
) 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=103640
) 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=103333
) 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=102436
) 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=102370
) as subquery
Public Service Alliance of Canada
<< Back to organisation profile
Features
03.03.2005
Le Fonds de justice sociale de l’AFPC fait partie des nombreux organismes qui joueront un rôle de premier plan dans la campagne mondiale invitant les leaders de la planète à remplir leurs promesses d’enrayer la pauvreté.
Story link
22.02.2005
Nycole Turmel, National President of the Public Service Alliance of Canada (PSAC) is calling on women in the union to adopt a political agenda in order to achieve change. She says that women's leadership is important in changing the face of power within their union, their workplaces, in their communities in Canada and beyond.
Story link
Related topics/regions:
[Canada]
16.02.2005
The 2,500 members of the Public Service Alliance of Canada (PSAC) working at Canada Post have accepted by a slim 55 per cent majority the final offer tabled by their employer. “Such lukewarm support is an accurate reflection of the simmering discontent of a large number of Canada Post employees,” said Luc Guevremont, President of the PSAC's Union of Postal Communications Employees (UPCE).
Story link
Related topics/regions:
[Canada]
31.01.2005
Workers with disabilities who are working in the federal public service are concerned that they will be the ones to end up paying for the increased privatization of government services. They feel privatization will have an effect on their working environment and on them personally as users of public services.
Story link
Related topics/regions:
[Canada]
30.01.2005
L' AFPC signera des conventions collectives avec le Conseil du Trésor pour plus de 100 000 de ses membres, éliminant ainsi la menace d'une reprise des grèves à l'échelle du pays tout comme à l'été et à l'automne de 2004.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-15
| Next >>
|
|
|
|
