Re: Trying to do SQL INSERT INTO with subquery

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 2010-10-25 15:13, Dan wrote:

The following query generates the data I want to see:
With MostRecentRR as (
select DISTINCT a.rvprcd, a.rvdtcode, max(a.rvrrdt) as Max_rvrrdt
from oprrfvp a
where a.rvsabb = 'WV'
group by a.rvprcd, a.rvdtcode )
Select * from oprrfvp b
where b.rvsabb = 'WV'
and exists (Select * from MostRecentRR a
where a.rvprcd = b.rvprcd
and a.rvdtcode = b.rvdtcode
and Max_rvrrdt = b.rvrrdt )

Try specifying the library, probably with sql syntax (lib.file). I'm
sure I've done that before. Excel just passes the query to the i, so
should be ok if the query is valid. It will complain that it can't
display the query graphically, but that's ok.

- --
Pete Hall
pete@xxxxxxxxxxxxxx
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAkzGC7EACgkQXczQcKdXKg5PHwCfae0QMVsJ9PfPYPMKwOstT34p
Lh8An2ZBrSTI32QuGAGbxUnIPXO3jGRj
=ahc3
-----END PGP SIGNATURE-----