Apparently, mySQL cannot do subqueries. Thus a query like this:
SELECT * FROM Artist WHERE ArtistId NOT IN (SELECT ArtistId FROM RIAAArtists)
...will not work. But, as mySQL argue, it's replaceable with a JOIN so you don't need it. Some shortcuts for OUTER joins don't work either (like WHERE Disc.F_ID *= Format.F_ID) don't work either, but they suck (they're hard to understand) and probably shouldn't be used anyway.
So I'm re-writing all the sloppy SQL I wrote two years ago for my CD database app. It's kind of fun in a sick and twisted kind of way. I'm halfway through the view code, the edit code is going to be interesting... as is the import from CDDB code.
So far all the code I've re-written will still work fine on SQL Server. Breaking the habits of a "lifetime" of programming.