🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Displaying only certain records in a SQL

#1265
From: David McCullough
Date: Tue, 24 Mar 1998 00:00
29 lines
1820 bytes
I have a report I am trying to pull from a query but I can not get it to
work. I used the SQL wizard but it takes forever and includes everything.
The basics are as follows plus the code from the SQL

SELECT DISTINCT Selldat2.quoteno, Selldat2.model, Selldat2.mathdisc,
Selldat2.code3, Selldat2.totpric, Selldat2.memo, Selldat2.salesman,
Selldat2.sellprice, Selldat2.customerid, Selldat2.refquotno,
Selldat2.freight, Selldat2.fob, Feat2.Picture, Feat2.Feature, Feat2.feamemo,
Quotelog."option", Quotelog.price
FROM "D:\BTSALES\selldat2.dbf" Selldat2
   INNER JOIN "D:\BTSALES\feat2.dbf" Feat2
   ON  (Selldat2.special = Feat2.SPECIAL)
   AND  (Selldat2.special = Feat2.SPECIAL)
   INNER JOIN "D:\BTSALES\quotelog.dbf" Quotelog
   ON  (Quotelog.quoteno = Selldat2.quoteno)
   AND  (Quotelog.quoteno = Selldat2.quoteno)

Selldat2.dbf will have 1 record  based on quoteno(numeric field)
feat2.dbf will have from 3 to 10 records  based on special (numeric field) I
can
                add the quoteno filed to this if required
Quotelog.dbf will have from 1 to 15 records and has the quoteno field also.

I am tring to filter this by a variable M->mquotno  (numeric) and it changes
when a new quote is started and data is entered or chosen and the process
starts all over again.
Any help would be greatly appreciated.
Thanks
Technical Details
Message-ID: <6f9cnm$gj03@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,c1e1fa092e4d4c4d,start
X-Google-Attributes: gidff5a1,public
From: "David McCullough" <72223.2320@compuserve.com>
Subject: Displaying only certain records in a SQL
Date: 1998/03/24
Message-ID: <6f9cnm$gj03@forums.borland.com>
X-Deja-AN: 337327122
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql