Please reply-all to the list and not just me directly.
I didn't realize you meant the table was empty when you did the full
insert. As Adrian pointed out, run your select using explain, it will show
you why you are producing no rows. Looking at your query just
superficially, the outer join looks
On 4/1/19 10:37 AM, Glenn Schultz wrote:
All,
The query below is designed to insert into a table. This works when I
have a single loan which I insert. However, if remove the part of the
where clause of a single loan the insert does not work. The table
fnmloan is a large table with 500mm +
On 4/1/19 12:37 PM, Glenn Schultz wrote:
All,
The query below is designed to insert into a table. This works when I
have a single loan which I insert. However, if remove the part of the
where clause of a single loan the insert does not work. The table fnmloan
is a large table with 500mm + r
On Mon, Apr 1, 2019 at 10:37 AM Glenn Schultz wrote:
> All,
>
> The query below is designed to insert into a table. This works when I
> have a single loan which I insert. However, if remove the part of the
> where clause of a single loan the insert does not work. The table fnmloan
> is a large
