In my project I am using 2 database i.e.
database-1 is MSSQL and
table-11,
table-12
database-2 is MySQL (Link Database)
tabel-21
table-22
I can insert a custom fields on the table-11 which get a query from table-12 as
custom field = (SELECT name FROM table-12 WHERE table-12.id = table.11.id)
The above query run find and got the value
And now I would like to insert a custom fields on the table-11 which get a query from table-22 (Link Table)
I try as
custom field = (SELECT name FROM table-22 WHERE table-22.id = table.11.id, conn("database-2"))