How to do a SQL type operation???
- To: mathgroup at smc.vnet.net
- Subject: [mg64352] How to do a SQL type operation???
- From: Richard Palmer <mapsinc at bellatlantic.net>
- Date: Mon, 13 Feb 2006 03:15:13 -0500 (EST)
- Sender: owner-wri-mathgroup at wolfram.com
Assume Table1={{a,Xa},{b,Xb},...,{n,Xn},...} where the key a can occur many
times and Xa is different each occurrence.
We also have table2={{a,Ya},{b,Yb},...,{n,Yn}}. Here a,b,...,n occur exactly
once.
How do I create table3={{a,Xa,Ya},{b,Xb,Yb},...,{n,Xn,Yn},...} by joining
the tables on the first column?
From the problem, if a (or b or c or ... n} is in table1, it is also in
table1 and visa versa.
The a,b,...,n,... Are small positive integers.
Thanks
- Follow-Ups:
- Re: How to do a SQL type operation???
- From: Pratik Desai <pdesai1@umbc.edu>
- Re: How to do a SQL type operation???