Hi all,
The mystery has been solved, it was a simple syntax error - please don't rush with your responses
DELETE FROM artist_genres WHERE customer_id = #customerID; (missing # )
thanks all, sorry to waste your time.
A well known homer simpson exclamation remark comes to mind...
