append fields for *where...*

Поиск
Список
Период
Сортировка
Искать
От
Johnny C
Тема
append fields for *where...*
Дата
Msg-id
2bffcc33050210144524608491@mail.gmail.com
Список
Дерево обсуждения
append fields for *where...* Johnny C <juandelacruz@gmail.com>
Re: append fields for *where...* Bruno Wolff III <bruno@wolff.to>
Re: append fields for *where...* Guillaume LELARGE <gleu@wanadoo.fr>
I have the following tables:

TABLE A
month   |   year   |   item         |   num
1              2005      myitem         003

TABLE B
num    |   date             |      descr
003         02-01-2005          blahblah
003         01-01-2005          toratora

I am trying to come up with something like:
select date,item,descr from TABLEA a 
LEFT OUTER JOIN TABLEB b ON  b.num=a.num
WHERE date=month-01-year;

How can you make month (append) - 01 - (append) year? and
pass that as a condition to the field date? Is this possible?

В списке pgsql-sql по дате отправления
От: Joel Fradkin
Дата:
От: Bruno Wolff III
Дата:
FAQ