At 23:07 12/10/2008, Helen Borrie wrote:
....
select
case
when (exists (select 1 from TBL_JOB_CARD_EMPLOYEE tjce
where tjce.JOB_CARD_ID = tjc.JOB_CARD_ID)) then 'Assigned'
else '--'
end
...

would possibly be nicer for you with

...
select
case
when (exists (select 1 from TBL_JOB_CARD_EMPLOYEE tjce
where tjce.JOB_CARD_ID = tjc.JOB_CARD_ID)) then 'Assigned'
else '--'
end
as Assigned

./hb