Article View: borland.public.vdbase.data.sql
Article #1265Displaying only certain records in a SQL
From: David McCullough
Date: Tue, 24 Mar 1998 00:00
Date: Tue, 24 Mar 1998 00:00
29 lines
1820 bytes
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-mailShow 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