0

I'm trying to create a query for a report but I don't seem to come with the right query for it, I'm kinda new at doing queries and reports, anyway here's what I have.

I have two tables that looks like this:

t1
-------------
|id | date |
| 1 | ..... |
| 2 | ..... |
| 3 | ..... |
| 4 | ..... |
-------------

t2
------------------------
|id | field1| field2 |
| 1 | ..... | ....... |
| 2 | ..... | ....... |
| 3 | ..... | ....... |
| 4 | ..... | ....... |
------------------------

i want to be able to select all fields from t2 based on a date from table 1 there are both linked with by the id, it's supposed to looks like this:
--------------------------------
|id | date | field1 | field2 |
| 1 | ..... | ....... | ....... |
| 2 | ..... | ....... | ....... |
| 3 | ..... | ....... | ....... |
| 4 | ..... | ....... | ....... |
--------------------------------

I think i need to use the inner join but i haven't been able to get the right syntax so if you could point me to the right direction i would really appreciate it

and also how can i add the results of all the rows so that it only displays 1 row, what I'm trying to do is add the totals in each field field1, field2 and then display those results on a bar graph, I'm I taking the right approach for this problem? or maybe this last step can be done by the reports software instead of the query? I'm using CR 2008

thanks guys.

3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by smantscheff
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.