General information
Category:
Coding, syntax & commands
I am trying to create a local view and having problems. VFP sometimes can create the view but later when I try to look at the resulting view (through MODIFY VIEW) I get unintelligible error messages. The tables involved are straightforward: order, order lines (orditem), purchase order lines (porditem), and invoice lines (invitem). The relationship is 1:M:M:M; i.e., one order can have multiple lines, one order line can relate to multiple purchase order lines, and one p/o line can relate to multiple invoice lines. The key fields in the tables are:
order: order_id
orditem: order_id + ord_line_no/100
porditem: porder_id + pord_line_no/100
invitem: invoice_id + inv_line_no/100
Assuming all fields of all tables are desired in the view, how should the code be written? For example,
create sql view test as;
select * from order inner join orditem;
on order.order_id = orditem.order_id;
...
How to finish this code?
Thanks in advance.
--Chris Lawrence
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