SELECT * FROM HEADER_TABLE A, ITEM_TABLE B
WHERE A.TRANSC_YEAR = B.TRANSC_YEAR
AND A.INT_TRANSAC_KEY = B.INT_TRANSAC_KEY
AND A.TRANSAC_INDICATOR = 'ISS'
AND A.PROCESS_ID = 'P'
AND B.TRANSAC_TYPE_CODE = 5.”
my problem is that i only need a few fields from table HEADER_TABLE A and all fields from ITEM_TABLE B. but my table B contains around 60 fields.
so i have to specify the name of each field instead of using * as both the tables have a few similar fields but with different values.
Is dere any way other than specifying all the field names to fetch limited value from table A nd all the values from Item table B
Bookmarks