What is the best way to script a query for combining data from 3 or more tables ?

ver: Firebird 1.5

Steve