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

**URL:** <https://forum.kirupa.com/t/two-table-delete-works-but-if-one-is-not-there-wont-run/252819>\
**Category:** programming\
**Created:** [February 24, 2008, 1:28am UTC](https://forum.kirupa.com/t/two-table-delete-works-but-if-one-is-not-there-wont-run/252819 "2008-02-24T01:28:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Multi\_Task](https://avatars.discourse-cdn.com/v4/letter/m/c6cbf5/32.png) [@Multi\_Task](https://forum.kirupa.com/u/Multi_Task)\
**Post date:** [February 24, 2008, 1:28am UTC](https://forum.kirupa.com/t/two-table-delete-works-but-if-one-is-not-there-wont-run/252819/1 "2008-02-24T01:28:06Z")

</div>

I am trying to delete from two separate tables with:

```auto

$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?