how to use join query

[maheshprof]

select FileAndpathname from V_LOGO where objectId=(selec t brandid from V_COMMERCIALIZE D_PRODUCT where PRODUCTREF=? And COUNTRYCODE=? And objectType=MQP) and LANGUAGECODE=? And COUNTRYCODE=?


how to create a join query for this

[amitpatel66]

select FileAndpathname from V_LOGO where objectId=(selec t brandid from V_COMMERCIALIZE D_PRODUCT where PRODUCTREF=? And COUNTRYCODE=? And objectType=MQP) and LANGUAGECODE=? And COUNTRYCODE=?


how to create a join query for this

Try this:

[code=oracle]

SELECT vl.fileandpathn ame FROM v_logo vl, v_commercialize d_products vcp WHERE vl.countrycode= vcp.country_cod e
AND vcp.productref = vl.procductref
AND vl.languagecode =vcp.languageco de
AND vcp.objecttype = 'MQP'

[/code]

Please post the table structure for the tables used in above query for better assistance from our experts!!