Re: Select problem
От | John McKown |
---|---|
Тема | Re: Select problem |
Дата | |
Msg-id | Pine.LNX.4.21.0008141132590.25426-100000@linux2.johnmckown.net обсуждение исходный текст |
Ответ на | Select problem ("Karl F. Larsen" <k5di@zianet.com>) |
Список | pgsql-novice |
On Mon, 14 Aug 2000, Karl F. Larsen wrote: > > I have a simple 3 table database with armycall as the common key > and it all works fine when I doa select like so: > > select user, doer > from data, biglist > where user.armycall = biglist.armycall; > > but if I want to get the column armycall and use: > > select user, armycall > from data, biglist > where user.armycall = biglist.armycall > > I get an error that armycall is ambiguous. > > Does anyone know how to correct this? > > Yours Truly, > > - Karl F. Larsen, k5di@arrl.net (505) 524-3303 - > You need to tell the SELECT which armycall you want since it is in both tables. Yes, the values are identical due to the WHERE clause, but the parser really doesn't know this. So try: select user, data.armycall from data, biglist where data.armycall = biglist.armycall Note - I think you have a transcription error in your example because you said user.armycall, not data.armycall in the WHERE clause. Anyway, I hope this helps, John
В списке pgsql-novice по дате отправления: