Two table DELETE works but if one is not there wont run?

programming
1

I am trying to delete from two separate tables with:


$query = "DELETE users, usersInfo FROM users, usersInfo WHERE users.userID = {$id} AND usersInfo.userID = {$id} ";

And everything works fine. However if the user (userID) is not in the usersInfo table the $query wont run. The usersInfo table is only for people who have been assigned, not necessarily all users.

What do I do in this situation?