I have three tables i.e sales,sales contract,order
sales has one key which is are related to order table,
sales.salesid=sales contract.salesid and
sales contract.contractno = order.contractno
i want to produce the report that display all the sales and sales contract and order as well therefore my sql statement as below
select sales.salesid,sales.name,sales.customerid, salescontract.contractno,contractdate, order.sn, itemorder,amount...
from sales,order,salescontract where sales.salesid=salescontract.saleid and salescontract.contractno=order.contractno into cursor aa
This result only display those record which have sales,sales contractno, and order but i want those record have sales and sales contractno but no order also come out
Is there any other way to do it to force those record have sales and sales contract but no order to come in the report
Thank for helping me
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only