Hi!
Yes. Try to change "=" to "==" for linking conditions, and assure all *_code field has the same length. Or just use SET EXACT ON command before query running.
>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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.