• Edited by HarSan Online a few seconds ago

Harsan first thing don't use title like help. Second you should post the DDL (create table...ect). Third I did not understand your question, may you explain better your issue?

Hello, you must use INNER JOIN.

See my example:

select ta.col1, ta.col2, ta.col3, tb.col4
from 
	tblA ta
inner join 
	tblB tb ON
	ta.col1 = tb.col1 and 
	ta.col2 = tb.col2

Regards! feel free to ask if you have any questions.