Hi


Ran the folloiwng script on a customers machine/database in dbSys

select
 tillreceipt.customerguid , customers.name as "name"

FROM
  "tillreceipt"

join tillreceipt.customerguid= customers.customerguid
where tillreceipt.value>50

And got ...error 11949 duplicate table or correlation name tillreceipt....



cut and paste the script to another machine/database works fine.


Any clues? Im stumped , it doesnt seem to make sense as far as an error goes



KevanB

Never mind.. sorted it