I tried to delete a joining tables with the same lbhc\_lb\_sku in table lif\_bookhascategory and lb\_sku in table lif\_books. I can't delete it.

Here's my SQL command:

```
DeleteCommand="DELETE FROM lif_books FROM lif_books CROSS JOIN lif_bookshascategory WHERE (lif_books.lb_sku = @lb_sku) AND (lif_bookhascategory.lbhc_lb_sku = @lb_sku)">

```

That returns:

```
Incorrect syntax near the keyword 'INNER'. 

```