If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
I have two tables like these;
LIB NAME SRCLIB SRCFILE SRCMBR
--- ---- ------ ------- ------
fd ds fds ee aw
aa aa aa aa aa
we nb ty ya as
bv sd de aa as
and
SRCLIBB SRCFILEB SRCMBRB
------- -------- -------
de aa as
ty aa as
.
SRCLIB=SRCLIBB
SRCFILE=SRCFILEB
SRCMBR=SRCMBRB
and I want to see lib and name where not in second table.
At last, I want to see
SELECT A.LIB, A."NAME" FROM BUSRA.ATABLE AS A EXCEPT SELECT ATA
BLE.LIB, ATABLE."NAME" FROM BUSRA.ATABLE AS ATABLE, BUSRA.BTABLE AS BTABLE wHERE ATABLE.SRCLIB = BTA
BLE.SRCLIBB AND ATABLE.SRCFILE = BTABLE.SRCFILEB AND ATABLE.SRCMBR = BTABLE.SRCMBRB