Query for a report

[mrjavoman]

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.

[VictorN]

Didn't you ever hear about JOIN?

SELECT t1.id, t1.date, t2.field1, t2.field2
FROM t1 INNER JOIN t2 ON t1.id = t2.id

[mrjavoman]

Didn't you ever hear about JOIN?

yeah i've heard about it but im just not that familiar with sql syntax I've been doing a bunch of googleing but this got me on the right track, thanks

[viperbyte]

If you ever need help with joins; something that you can do is build the query with Query Design in Microsoft Access and view the SQL in SQL view. If you aren't familiar with that, it's a really easy way of doing queries that won't take much time to learn how to use. Then you will be able to see how it's done and won't depend on it or the peanut gallery.