joined:Dec 2, 2008
I'm writing a query that selects from 4 tables. Here is a summary of the important columns (Most of the information comes from Table 1):
Database 1 - Table 1 (instalments)
Database 1 - Table 2 (orders)
Database 1 - Table 3 (writers)
Database 2 - Table 4 (customers)
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.
Any help appreciated, thanks.