General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
They are characters. Does it make any difference?
>Hi!
>
>What is a type of the fields "*_code" in lookup table and main tables used for joining? Are they character?
>
>>Hi!
>>
>>I've created a view with view designer. It has one "Invioice" table and 3 related lookup tables ("customer", "type", "country") all related to "Invioice". I join these tables and select all fields from "Invoice" and "...name" fields from lookup tables ("customer", "type", "country"). In the result cursor the last lookup table's "...name" filed doesn't seem to show the correct names (all the rows shows the same data while the codes in "Invioice" table are different). What can be wrong? The first 2 related tables works fine. I've tried to change the order of the lookup tables but the problem is allways with last table.
>>
>>SELECT Invoice.*, Customer.cust_name, Type.type_name, Country.count_name;
>> FROM data1!Customer INNER JOIN data1!Invoice;
>> INNER JOIN data1!Type;
>> INNER JOIN data1!Country ;
>> ON Country.count_code = Invoice.count_code ;
>> ON Type.type_code = Invoice.type_code ;
>> ON Customer.cust_code = Invoice.cust_code
>>
>>Thanks for any help.
Previous
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