So firstly I have the order_id from Table 1. Then I need to get the customer for that order_id from Table 2. Then I need to get the customer's first name and surname from Table 4, in another database, based on the customer ID from the join on Table 2. Lastly, I also need to join the writer's first name and surname on Table 1's writer ID.
Not really sure about stacking up joins like this, especially as it's across 2 different databases.