Problem-select string made by two other selects in Access database to be used as select string for filling the dataset in C# windows form

Question

Hi,

I have an access  database with three tables. I made one query using two other queries from the same database to form the select I need. But now I don't know how to convert it in select which would work in my C# windows form as well. I use this select to fill the dataset for making the crystal report later.

Here is the select I have in access query:

SELECT firstquery.GBR, firstquery.Gorivo, secondquery.SUMKM, ((firstquery.Gorivo/secondquery.SUMKM)*100) AS Prospotrgor, firstquery.Addblue, firstquery.Addbluegor, firstquery.Antifriz, firstquery.Motmaslo, secondquery.pockm, secondquery.krajkm, secondquery.RAZLIKA, secondquery.Poslprov, secondquery.Poslserv, secondquery.Zabeleska
FROM firstquery LEFT JOIN secondquery ON firstquery.GBR = secondquery.GBRV;

firstquery is the name of the first query with the first select statement, and secondquery of the second query respectively.

Could anybody help me please?

Thank you in advance