If we have views that have multiple joins, unions, sub-selects etc, can we use the same sql statement to create virtual tables ?

Is a virtual table the best way to move a view from vfp to Lianja ?