Advertisement

10.14.2008 at 10:43AM PDT, ID: 23813711 | Points: 500
[x]
Attachment Details

Adding another simple condtion

Asked by jtuttle99 in SQL Query Syntax

Tags:

I can't figure out why I can't put this simple condition in to the SQL below in WHERE clause.

AND Attribs.Descriptor ='A'


"SELECT DISTINCTROW Items.* FROM Items INNER JOIN Attribs ON Items.ImageID = Attribs.ImageID WHERE Items.deleted <> 1 AND Attribs.Descriptor ='BND' ORDER BY Items.Priority, Items.ImageID"

I don't get any result if I add "  AND Attribs.Descriptor ='A'  "  although the date exists.
What am I missing?
Start Free Trial
[+][-]10.14.2008 at 10:47AM PDT, ID: 22713821

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 10:59AM PDT, ID: 22713949

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 11:14AM PDT, ID: 22714110

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 11:15AM PDT, ID: 22714127

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 11:22AM PDT, ID: 22714180

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 02:10PM PDT, ID: 22716021

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.15.2008 at 06:39PM PDT, ID: 22727466

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628