Good morning,
I'm using Openquery to retrive data from DB2 z/OS Mainframe via MS SQL 2005 ENT linked server. I'm using MS Access as front end app to search for a record and display its values and then fill in earnings tax return. I have been able to retrive records just fine but I'm bit stumped when it comes to join in Openquery. I want to be able to add City/State from ZIPX_CODE table based on MSTR_ZIPC value from ETAX_MASTER table.
Here is SQL for getting specific values from ETAX_MASTER table;
SELECT MSTR_FIDN, MSTR_NAM1, MSTR_NAM2, MSTR_STRT, MSTR_ZIPC, MSTR_ATYP, MSTR_ADAT, MSTR_AEND FROM OPENQUERY(TSTESA5,'SELECT * FROM stl01.ETAX_MASTER where MSTR_FIDN =''26202479000''')
And here is the retrival of City and State just using zip code 63135;
SELECT ZIPX_CODE, ZIPX_CITY_ST FROM OPENQUERY(TSTESA5,'SELECT * FROM STL01.ETAX_ZIPX WHERE ZIPX_CODE = 63135')

Now I want to join these two and use MSTR_ZIPC code from ETAX_MASTER table and ZIPX_CODE and retrieve ZIPX_CITY_ST.

Thanks a lot


Amir