Access doubt

[sandyboy]

Hi,

I am new to access but i have some sql experience. Can you guys please help me with this:

I have two tables t1 and t2. t1 has a column c1 and t2 has c2 . c1 and c2 are almost same.I want all the records in t1 where the values c1 and c2 are equal.
i.e select * from t1 where c1=(select c2 from t2). How can i do this in access. Can you guys please guide me.

[mlcampeau]

Hi,

I am new to access but i have some sql experience. Can you guys please help me with this:

I have two tables t1 and t2. t1 has a column c1 and t2 has c2 . c1 and c2 are almost same.I want all the records in t1 where the values c1 and c2 are equal.
i.e select * from t1 where c1=(select c2 from t2). How can i do this in access. Can you guys please guide me.

Create a new query. You can either go to design view or sql view to create the query, but since you have experience with sql, you may find it easier to use the sql view. You can try:

SELECT * 
FROM T1 RIGHT JOIN T2 ON T1.C1 = T2.C2;

If that doesn't give the correct results try a LEFT join instead.

[Rabbit]

Actually, I think they need an INNER JOIN. I don't think they want all records from any one table, only the ones where they match up. So INNER JOIN rather than an OUTER JOIN.

And this is all SQL, Access has nothing to do with it.

[mlcampeau]

Actually, I think they need an INNER JOIN. I don't think they want all records from any one table, only the ones where they match up. So INNER JOIN rather than an OUTER JOIN.

And this is all SQL, Access has nothing to do with it.

I understood it that he wanted all the records from table 1. But if he wants only the records that match up, then yes, an INNER JOIN would be correct. Thanks for adding that Rabbit.