mardi 3 avril 2018

select value form one table update value for fetched value in single query

I have two tables request and details.request table id is foreign key for details table I want I have price(321) and request_id(1819AM002) value.I want to fetch value id using request_id in request table update price field value in details table in single query.Is it possible to achieve in single query

 request table  
  id request_id  name  type
  1 1819AM001    XXX    A
  2 1819AM002    YYY    A

 Details table
 id request_id  price
  1  2           133



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire