Solved

Sql Query Ambiguous column

Posted on 2013-12-19
3
561 Views
Last Modified: 2013-12-19
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
Comment
Question by:rflorencio
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
awking00 earned 500 total points
ID: 39729975
where COALESCE(mar.name,obreq.descrip) like '%xxx%'
0
 

Author Closing Comment

by:rflorencio
ID: 39730022
Thanks awking00
0
 
LVL 32

Expert Comment

by:awking00
ID: 39730201
You're most welcome.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now