How is the syntax of a query using Inner Join delete in sql, to compare two-table code and exclude to be equal?
Sales item table. in the item sale table, a sale has been registered whose code is 4. To execute the reversal, if applicable, the user can remove.
ControltableBox.Whenreversed,therecordoftheitemsaletablewillberemovedandatthesametimewillberemoved,therecordwhosecodDoc=4.Thisdocumentcodeisgeneratedwhenthesaleisfinalized.