Join two tables using SQL query

[vaib288932]

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

[CitricAcid]

So is it like you want to avoid those fields that are similar in each other? If it is the case then you can use WHERE clause in which you can use NOT EQUAL (<>) comparison to avoid those fields.

[vaib288932]

actually i need the fields from both the tables which could have same name but they can have different values. so i can't avoid those fields.

[CitricAcid]

Why don't you use subqueries in such case? First create a query where you check for validations in Table A. Include this query in subquery of another query where you make your validations for Table B. I hope I was clear in my point.