The script will be run daily and the output 'table' is sent to a web server.

I'm actually using sqllite with php for the script but the client's database uses...

what would the trigger contain welshcorgi?

Thanks again, I've traced the duplication back to where more than one patient does have only one phone number ..makes sense when the extra patients could be the children.

Is there...

Thanks guys for the speedy response. I actually used something similar using WHERE instead and it's returned the same amount of rows. However both WHERE and INNER JOIN seems to...