Sql Query Ambiguous column

I would do a filter in description column, but an error is returned:

Ambiguous column name 'description '.

How can solve.

select  ObrEq.mat, COALESCE(mar.name,obreq.descrip) as description
from obreq
left join Mar on ObrEq.IdMar=mar.IdMar
 where description like '%xxx%'

Open in new window

rflorencioAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
awking00Connect With a Mentor Commented:
where COALESCE(mar.name,obreq.descrip) like '%xxx%'
0
 
rflorencioAuthor Commented:
Thanks awking00
0
 
awking00Commented:
You're most welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.