Help would be appreciated.
This is my sql query:

{arijdatatable bPaginate="true"} {arisqltable} {arisqltablequery}SELECT id AS ID,firstname AS NAME, lastname AS Surname, cb_membershipcategory AS Category, cb_membersince AS MbSince, cb_renewaldate AS RenewDate, cb_organisationname AS Company, cb_city AS City, cb_country AS Country, cb_membershipstatus AS Status, email AS Email FROM qgth1_comprofiler INNER JOIN qgth1_users ON qgth1_comprofiler.id=qgth1_users.id {/arisqltablequery} {/arisqltable}{/arijdatatable

It returns a blank page.
But, SQL on one table without INNER JOIN works fine.
Many thanks for any suggestions.

Hello,

The extensions supports all constructions which are supported by database. In your case a blank page appears because a PHP error occurs, it appears if "memory_limit" is exhausted.

Install PHP Settings plugin and try to increase value of "memory_limit" PHP variable. If it doesn't help, provide a link to a page where the problem occurs and a temporary access to your J! backend by email so we can investigate the problem.

Regards,
ARI Soft