I have 2 tables
1) tm_Customer(custId,CName,address,contactNo)
2) tm_booking(bID,Amount,CustID)
data in table
1) tm_customer
1, jagdish,asdf,122334
2, ghi, qwert,34455
3, jkl, asdfgh,34521
4, iuy, lkjff,3434
2) tm_booking
1, 12000, 1
2, 123000, 2
3, 2345, 3
4, 1234, 1
5, 123, 4
I am executing query as following:
select bid,cName,address,contactno,amount from tm_booking b,tm_customer c where b.custID=c.custId and bid=2;
so result should be
2 ,ghi, qwert, 34455, 12300
I am getting this result in Datatable but when i am assigning this datatable to crystall report. It shows me like this:
2 ,Jagdish, asdf, 122334, 12300
2 ,ghi, qwert, 34455, 12300
2 ,jkl, asdfgh, 34521, 12300
2 ,iuy, lkjff, 3434, 12300
error is single record of booking table assigned to all record of customer table in crystal report.
can any one suggest me solution???
Thanx in advance.