It should be noted to anyone that might stumble upon this that if these are INNODB tables that have foreign keys on those id fields then you can't use the query.