Building an SQLJOINcommandstartsas aregularSQL SELECT command, but insteadofspecifyingfieldsfromjustonetable, you can specifyfields from more than one table.
Since last autumn, people from outside the EU applying for a visa to join their spouse or partner now have to prove they have a basic command of English before their application is approved.