Datas from different tables in one crystal report..

[shahriar2403]

Let, i have a msàccess db with 3 tables having 'cost' field in all of them . Now in my report i want to
1) Show the sum of costs of indivisual table under the heading of each table (let $3000 for every table) &
2) show the sum of all the sum value of individual tables (here it would be $9000) at the bottom of the page under 'total' heading. How can i do it? Plz help me.

[ryan_vietnow]

Use LEFT JOIN command in your SQL Query to combine all the 3 tables.

[debasisdas]

Use suitable joins to retrive data from multiple tables.

[shahriar2403]

Would you plz kindly give some coding with example. Actually i am new in it. If da example is close to my problem that would be very much appreciable...