troubleshooting Question

Foxpro 7 SELECT with JOINS

Avatar of anderdw2
anderdw2Flag for United States of America asked on
FoxPro
5 Comments1 Solution4708 ViewsLast Modified:
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)

ASKER CERTIFIED SOLUTION
Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros