At 19:48 12/10/2008, you wrote:

>Thanks Helen and Kjell
>
>Helen won't that create multiple rows if there is more than one
>employee?

Yes, it will, if you have multiple employees on that job card. You said "I don't need to count the employees, just find out if there is at least one per record in the tbl_job_card table".

So what you really meant was, you want one and only one record if there are *any" matching records for the tbl_job_card ID in TBL_JOB_CARD_EMPLOYEE, is that correct?

./heLen