Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

I am trying to join two databases in an SQL query. Database A has a table with a 5 digit client number and another table with a 5 digit matter number. The other database, B, has a table with one field ...