Need help with scripting

[Jas Singh]

Hello. I am a beginner to SQL and I am working on a work related request. I already know the tables and fields to work on this request. I just need to know the structure of this script. Can someone please help?

Here's the description of the request: " Need a list of loans that are in a mandatory flood zone (A or V) with an escrow type 23. From January 1, 2010 to current."

For Escrow type, the database is AS400PL.AS400PL .MTGLIBP1.CHESC RAB and the field is ESCTYPE

For Flood Zone, the database is AS4CS01.AS4CS01 .MTGLIBPN.INSOL DPL and the field is FLZONE.


tHANK YOU FOR THE HELP!

[ck9663]

You're going to need the JOIN clause to link these two tables and WHERE clause, to filter the rows.

Start working on it, post when you hit a wall, and we'll start from there...

Good Luck!!!

~~ CK