How to get the result of the SQL JOIN query into the ListView?

[normunds]

Hi,

I tried to use Filippo's ListView, but with no success. As far I could understood the help file, it's source can be only one SQL table at a time.
I suppose there exists some techniques to overcome this limitation, but unfortunately it is beyond my actual knowledge.

Or maybe Agraham's ListView is better choice for use with SQL JOIN queries? Unfortunately I even can't figure out, how to fill it with SQL data. I searched in forum for a sample, but with no luck.

In both cases there is no problem with help files. Obviously there is a problem because of my (so far) limited knowledge.

The short piece of code will be the best explanation, however any help will be higly appreciated. Hope I'm not asking too much.

[Filippo]

from ListView.chm:

Syntax:
lv.LoadSQL (SQLFile Name As String, Table As String, SQLCommandText As String , SortByColumnName As String, Create Columns As Boolean)

[normunds]

You're right, of course - I overlooked the "SQLCommandText As String" part. Thank you very much for pointing.