Sql Problem

Article View: borland.public.vdbase.data.sql

Article #187

Back to borland.public.vdbase.data.sql Previous Next

#187

From: Scott
Date: Fri, 12 Mar 1999 00:00

18 lines
1067 bytes

I have this SQL statement below

select  a.x_partnum, a.x_serial, a.purorder,  a.psno, a.dte_ret, b.vendnum,
c.vendor, a.val from "&history" a, purorder b, vendor c where a.purorder =
b.purorder and b.vendnum = c.vendnum and dte_ret IS NOT NULL and credit IS
NULL

When I output that to the report that I am doing I don't get any information
but when I leave out

and credit IS NULL

I get some information, but my field for credit, is null because there is
nothing in that field.  So my orginal sql statement should work but I don't
know why it doesn't.  Any help on this would be of great use.  Thanks in
advance.

Scott

Technical Details

Message-ID: <7cbefb$o3b10@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5502ca5e6d5fde3c,start
X-Google-Attributes: gidff5a1,public
From: "Scott" <free_style@yahoo.com>
Subject: Sql Problem
Date: 1999/03/12
Message-ID: <7cbefb$o3b10@forums.borland.com>
X-Deja-AN: 454243066
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql