Perfect - now getting

Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "name" is a duplicate.

Owh the joys of mySQL and MSSQL....

** No need for a reply to this just passing comment... ranting really.

Thanks for the help!