Including records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rml - 06 Jul 2006 19:47 GMT

I have a query that pulls back all records that have a >0 value. It works
fine. The problem is that I have a few records that contain a 0 value that I
would like to include in my results. These results include part number,
price and descritions fields. Maybe I can use the part number to include
those records? How can I achieve both?

Thanks.

Reply to this Message

Rick B - 06 Jul 2006 20:12 GMT

Just use an "OR" condition.

Part Number = "xxxx" *OR* value is >0

Signature

Rick B

>I have a query that pulls back all records that have a >0 value. It works
> fine. The problem is that I have a few records that contain a 0 value
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

MGFoster - 06 Jul 2006 21:30 GMT

> I have a query that pulls back all records that have a >0 value. It works
> fine. The problem is that I have a few records that contain a 0 value that I
> would like to include in my results. These results include part number,
> price and descritions fields. Maybe I can use the part number to include
> those records? How can I achieve both?

The WHERE clause of the query:

WHERE column_name > 0
OR (column_name = 0 AND part_nbr = 1234)

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message