crystal report with using two differrnt tables feilds

Question

hi. I am using Visual studio 2010 with c# window application. I want create crystal report using the feilds of two different tables. then wht i have to write for this? I have try to join it... but i don't know how to fill onw sql statement with dataset.

Manoj Bhoir · Answer

Hi You can use Inner Join in your SQL Statement. Check this link for Inner Join http://www.w3schools.com/sql/sql_join_inner.asp Create New Data Set With that SQL Statement and use it in your Report.