Joomla execute raw sql

$db = JFactory::getDbo();
$sql = "UPDATE TableB SET TableB.value = (SELECT TableA.value FROM TableA WHERE TableA.name = TableB.name);
$db->setQuery($sql);
$result = $db->query();

Similar codes

6 votes145 views2 answers
Oracle
SQL
3 votes151 views1 answer
Laravel paginate raw sql
SQL
0 vote207 views1 answer
Sql declare variable single line
SQL
0 vote186 views1 answer
Best sql collation
SQL
0 vote152 views1 answer
How to find username and password in oracle 18c
SQL
5 votes152 views1 answer
Oracle find foreign key dependencies
SQL
0 vote157 views1 answer
How to fetch unique records from two tables
SQL
7 votes155 views2 answers
Html to react converter
SQL
2 votes141 views1 answer
Oracle sql drop table purge
SQL
2 votes150 views3 answers
Write sql query to find the second highest salary of employee
SQL