Re: SELECT but only if not present in another table

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SELECT but only if not present in another table
Date: 2020-12-06 19:30:08
Message-ID: CAADeyWjubL-reYO_EqJHU+QjnP03u+gOzmRds5sfzQ3FXT_HQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you, Steve -

On Sun, Dec 6, 2020 at 6:50 PM Steve Baldwin <steve(dot)baldwin(at)gmail(dot)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!

In response to

Browse pgsql-general by date

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