I am using the pecee-pixie library.
I am trying to update a column from one table based on values from another table however when i ran my query i simply updated the values with a text table2.values
rather with the actual values.
This is my query:
$table1 = $query_builder->table('table1');
$table1
->leftJoin("table2", "table1.id", "=", "table2.join_id")
->whereNotNull("table2.values")
->update(['table1.values' => 'table2.values']);
I would mind using raw queries but i'd prefer if i didnt have to write the whole query raw. Anybody has any ideas?