B4X FEED Help with SQL - query

[PracticalBot]

Don't know if it is possible but if it is, how can I using SQL get a query result as in this layout:

Person	Client 2016	Client 2017	Supplier 2016	Supplier 2017
Mr. Green	USD 500	USD 300	USD 200	USD 400

from a table (let us say an Invoice table) as follows (of course it could be an csv-file):

Mr Green	Client, year 2016	USD 500
Mr Green	Client, year 2017	USD 300
Mr Green	Supplier, year 2016	USD 200
Mr Green,	Supplier, year 2017	USD 400

It's late and I am stuck but perhaps someone can give me a helping hand.

Probably involves grouping..

Thanks.

برای دیدن لینک ها باید ثبت نام کنید