Need help with the join condition

[ashmitp869]

Hi there ,

if anyone can assist with the join 

I am using this condition -

on
app.[Visit ID] ='%' + nap4.[Service Event ID] + '%'
and
app.[Appt Date] =nap4.[Service Date]
and ( app.[Appt Location] Like 'D&A%' and nap4.[Service Unit Name] Like 'D&A%' )

But the join condition is not working 

[James5654]

The join condition compares two columns, each from a different table. To execute a join, Oracle Database combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE . The columns in the join conditions need not also appear in the select list. ExpressHR