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 по дате отправления: