It should be possible to create the MySQL box as a linked server, then use normal queries to MySQL to get the data you need. I'd be curious to see if it works, however, as MySQL syntax is quite different than MS-SQL.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3