Access :: Use Outer Joiin With Microsoft Visual Web Developer 2008?

I want to know how do I use outer joiin with microsoft visual web developer 2008.

I am using an access database. There are two table in the table t1 and t2.

I want to list the items in both table that have the same id.

my query is as follows:

select t1.id, t1.date, t1.count, t2.date, t2.count from t1 outer join t2 on t1.id=t2.id;

I am completely depressed ... I have been trying this for more than 200hrs.