Re: SELECT but only if not present in another table

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: SELECT but only if not present in another table
Дата
Msg-id CAADeyWjubL-reYO_EqJHU+QjnP03u+gOzmRds5sfzQ3FXT_HQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT but only if not present in another table  (Steve Baldwin <steve.baldwin@gmail.com>)
Список pgsql-general
Дерево обсуждения
Thank you, Steve -

On Sun, Dec 6, 2020 at 6:50 PM Steve Baldwin <steve.baldwin@gmail.com> wrote:
Can't you just use table aliases? So, the outer word_moves would become 'word_moves as wm', word_puzzles would become 'word_puzzles as wp', and the where clause 'WHERE wp.mid = wm.mid' ?

table aliases have worked for me! 

В списке pgsql-general по дате отправления:

Предыдущее
От: Steve Baldwin
Дата:
Сообщение: Re: SELECT but only if not present in another table
Следующее
От: electrotype
Дата:
Сообщение: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?