R help - Mar 2003 - combining dataframes

Hi

I want to combine 2 dataframes (t1 and t2) in order to get a third one
(t3). The dataframes are below.

In SQL I would do something like:

SELECT t1.f1,t1.f2,t1.f3,t2.f4 FROM t1, t2
WHERE t1.f1=t2.f1 AND t1.f2=t2.f2

How can I do it with R ?

Thanks

EJ
> t1
  f1 f2 f3
1  A  C E1
2  A  D E2
3  B  C E3
4  B  D E4
> t2
  f1 f2 f4
1  A  C F1
2  A  C F2
3  B  C F3
4  B  C F4
5  A  D F5
6  A  D F6
> t3
  f1 f2 f3 f4
1  A  C E1 F1
2  A  C E1 F2
3  B  C E3 F3
4  B  C E3 F4
5  A  D E2 F5
6  A  D E2 F6

In a message dated 3/22/03 11:56:48 AM Eastern Standard Time, 
ernesto@ipimar.pt writes:

> Hi
> 
> I want to combine 2 dataframes (t1 and t2) in order to get a third one
> (t3). The dataframes are below.
> 
> In SQL I would do something like:
> 
> SELECT t1.f1,t1.f2,t1.f3,t2.f4 FROM t1, t2
> WHERE t1.f1=t2.f1 AND t1.f2=t2.f2
> 
> How can I do it with R ?
> 
> Thanks
> 
> EJ
> 
A two-step solution will be to (1) subset the dataframes t1 and t2, making 
two dataframes with the desired columns from each , and (2) use
"merge" to
combine them.
--anupam


	[[alternate HTML version deleted]]