Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding Record Filtering in SQL Query
Message
From
19/06/2000 21:52:51
Antonio Gubaira
Ingenieria Y Sistemas
Valencia, Venezuela
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Avoiding Record Filtering in SQL Query
Miscellaneous
Thread ID:
00382039
Message ID:
00382039
Views:
49
In the following example, how can I avoid record filtering (discarded from query results) when InvHead.SalesNo or InvHead.CourNo are left blanked ?

I have the following tables:

InvHead: (InvNo, InvDate, CustNo, SalesNo, CourNo)
InvDetl: (InvNo, Item,Qty,Price,Disc)
Customer: (CustNo,Name,Address,Phone)
Salesmen: (SalesNo,Name,Address,Phone)
Courier: (CourNo, Name Address, Phone)

My SQL stament is:

SELECT InvHead.InvNo, CustNo, InvDate, Item, Qty, Price, Disc, Customer.Name, Salesmen.Name, Courier.Name ;
FROM InvHead, InvDetl, Customer, Salesmen, Courier ;
INTO TABLE Temp ;
WHERE InvHead.InvNo = InvDetl.InvNo AND ;
InvHead.CustNo = Customer.CustNo AND ;
InvHead.SalesNo = Salesmen.SalesNo AND ;
InvHeadCourNo = Courier.CourNo ;
ORDER BY InvDate, CustNo, InvHead.InvNo
Thanks in Advanced or Hope This Helps
Next
Reply
Map
View

Click here to load this message in the networking platform