sql problem

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by scott Fri, 12 Mar 1999 00:00

#186

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads