I am starting to write apps in AdonisJS for a new Job I have started.
The data I am working with is in MSSQL and spread across a number of databases on the same server. As an example, the following SQL brings in data from two databases PROCUREMENT and LNDW
select * from PROCUREMENT.static.ln_local_buyers lb join LNDW.dbo.TDIPU001_ITEM_PURCHASE_DATA ipd on ipd.Buyer = lb.Buyer
I have setup a working connection to MSSQL, but the database is set as PROCUREMENT, is it possible to setup the other databases as seperate connections so lucid can create a join like in the example code above?