• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 588
  • Last Modified:

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

0
rflorencio
Asked:
rflorencio
  • 2
1 Solution
 
awking00Commented:
where COALESCE(mar.name,obreq.descrip) like '%xxx%'
0
 
rflorencioAuthor Commented:
Thanks awking00
0
 
awking00Commented:
You're most welcome.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now