We have a legacy application that uses an advantage database server, serving .dbf We access the data with Foxpro 7. I'm trying to do a query like the following, but cannot get the syntax right for the JOIN here is my sql without the join
Close Data
SET EXCL OFF
SELECT s.batch, s.code, s.class, s.nir, s.account, s.arrival, s.return, f.name, s.describe, s.due, b.item as Special_Item, b.amount as Special_Amt, ;
s.farmname, c.first, c.last, c.business, c.discount, c.pricetier, s.postage, c.billto, c.address1, c.city, c.state, c.zip, ;
c.fax, c.phone, c.email;
FROM samples s, samplexp x, clients c, feedcode f, billitem b;
WHERE s.batch = 11748 AND x.location="LANCSAMPLE" AND;
(s.sampleid = x.sampleid) AND;
(s.account = c.account) AND;
(s.feed_type = f.feed_type) AND;
(s.account = b.account)
COPY TO C:\lancasterTest\lancBill TYPE DELIMITED
Return
I'm trying to do an LEFT/RIGHT OUTER JOIN on the following, as I don't want the data from billitem all to come over. (s.account = b.account)
Our community of experts have been thoroughly vetted for their expertise and industry experience.