When joining two SharePoint lists, you will usually come up with a query that contains three statements.

Two “list” statements used to retrieve data from your SharePoint lists and a sqlQuery statement that will contain a SQL SELECT clause for joining the two SharePoint lists.

In current version, you don’t have much help when writing the SELECT clause. For simple joins, that may not really be a concern. For more complex SELECT clauses, writing down the field and list names may be a more tedious task.

Version 3.4 will provide some intellisense features that will make it unnecessary to look around for column names:

As shown in the following screen shots, you will notice that useful information is provided when navigating over the elements :

Columns are automatically filtered :

We hope you will enjoy this new feature.