How to delete from multiple tables using inner joins. Dynamic Query

Hello Friends,

I am trying to delete all records associated to a id from multiple tables using inner joins.

My query currently looks as follows:

        $query = Database::getConnection()->delete('dir_business_listings', 'a');
        $query->join('dir_bl_location', 'b', 'a.dbl_id = b.dbloc_dbl_id');
        $query->join('dir_bl_details', 'c', 'a.dbl_id = c.dbd_dbl_id');
        $query->join('dir_bl_slides', 'd', 'a.dbl_id = d.dbs_dbl_id');
        $query->condition('a.dbl_id', $listing_id);
        $results = $query->execute();

and I am getting 

TypeError: Argument 2 passed to DrupalCoreDatabaseConnection::delete() must be of the type array, string given

Any help or advice would be GREATLY appreciated <3

Kind regards,

Matt

Drupal version: 


Source: https://www.drupal.org/taxonomy/term/4/feed