Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2006
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2006

[Date Index] [Thread Index] [Author Index]

Search the Archive

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


  • Prev by Date: Descarta2D
  • Next by Date: Re: eps color export
  • Previous by thread: Re: Descarta2D
  • Next by thread: Re: How to do a SQL type operation???