sql problem

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

Article #186

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

#186

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

13 lines
1057 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: <7cben4$nt017@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,ec18da699b43e974,start
X-Google-Attributes: gidff5a1,public
From: "scott" <free_style@yahoo.com>
Subject: sql problem
Date: 1999/03/12
Message-ID: <7cben4$nt017@forums.borland.com>
X-Deja-AN: 454243065
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql