Styjun

I have these two tables:

Table: REASON

id | name
---|------------
1 | gold_sell
2 | gold_buy
4 | Silver_sell 

Table: REASON_TO_TRANSACTION

reason_id | transaction_type
----------|-------------------
1 | sell
2 | buy
4 | pko

where id from table reason is linked with reason_id from reason_to_transaction.

I want to delete all rows with id = 1 from these two tables.

Can someone help me?

I'm using SQL Server(phpmyadmin).

Variable name is for getting the current activeItem and delete it.

I have written following SQL command:

DELETE rt 
 FROM reason_to_transaction rt 
 INNER JOIN reasons r 
 ON id=reason_id 
 WHERE reasons.id=reason_to_transaction.reason_id 
 AND name = 'gold_sell'

I also have this angular code:

$scope.deleteItem = function()
 console.log($scope.activeItem);
 var objectToSave = 
 name: $scope.activeItem.name,
 id: $scope.activeItem.id
 ;

 if($scope.activeItem.id)


 defaultAdapter.query('DELETE rt FROM reason_to_transaction rt INNER JOIN reasons r ON r.id = tr.reason_id WHERE name = :name',
 replacements: objectToSave, type: Sequelize.QueryTypes.UPDATE 
 ).then(projects => 
 console.log(projects);
 $scope.editMode = false;
 $scope.activeItem = false;
 $scope.refresh();
 );
 else 
 defaultAdapter.query('DELETE rt FROM reason_to_transaction rt INNER JOIN reasons r ON r.id = tr.reason_id WHERE name = :name',

 replacements: objectToSave, type: Sequelize.QueryTypes.UPDATE 
 ).then(projects => 
 console.log(projects);
 $scope.editMode = false;
 $scope.activeItem = false;
 $scope.refresh();
 );

 
 ;

And also have html submit form:

<div class="editMode1" style="display: none;">
<div class="form">
<form ng-submit="saveItem(reasonsForm.$valid)" name="reasonsForm">
<div class="row">
 <div class="col-sm-6">
 <div class="form-group">
 <label for="currency_code">Име на основание</label>
 <input type="text" class="form-control" required ng-model="activeItem.name" placeholder="Име на основание за редактиране" />
 </div>



 </div>
 </div>
 <button class="btn btn-primary" ng-disabled="reasonsForm.$invalid" type="submit">Save</button>
 <button class="btn btn-primary" type="submit" ng-click="deleteItem()">Delete</button> <!--ng-click="createUser()"-->

 <button class="btn btn-primary" id="cnlbtn" type="button">Cancel</button>


</form>
</div>
</div>