Re: need help with select statements

2001-08-30 Thread Ian Barwick
On Thursday 30 August 2001 15:28, Andre Konopka wrote: > Hi, > > I have, three tables (one,two, three) with the rows id/value. id is the > key for all the tables. > > > with > > > select value from one where id=xx; > select value from two where id=xx; > select value from three where id=xx; > > > I

need help with select statements

2001-08-30 Thread Andre Konopka
Hi, I have, three tables (one,two, three) with the rows id/value. id is the key for all the tables. with select value from one where id=xx; select value from two where id=xx; select value from three where id=xx; I can select all values from the tables with the id=xx. How can I do this wit