2
Reply

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

Nel

Nel

Nov 30 2011 4:02 PM
1.3k

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


Answers (2)
Next Recommended Forum