Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT but only if not present in another table - Mailing list pgsql-general

From Alexander Farber
Subject Re: SELECT but only if not present in another table
Date
Msg-id CAADeyWjubL-reYO_EqJHU+QjnP03u+gOzmRds5sfzQ3FXT_HQA@mail.gmail.com
Whole thread Raw
In response to Re: SELECT but only if not present in another table  (Steve Baldwin <steve.baldwin@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Steve Baldwin
Date:
Subject: Re: SELECT but only if not present in another table
Next
From: electrotype
Date:
Subject: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?