Trouble with Binary links

[Alex Shaw]

Hi Ruslan

Just started playing with binary links and am having mixed results.

I've put a small & simple test database together at:
http://www.harryscollar.com/binarylinktest.zip (only 12KB)

The main database is called "test.vdb" & there are two sql queries 
displaying the problem.

"query1.sql" displays all the linked items ok (6 in total)

"query2.sql" tries to display linked items based on a simple where 
clause but gives an incorrect result, I get 2 results instead of the 
required 3.

If you change the where clause to:
where infozones.zonename = 'zone 2' OR
where infozones.zonename = 'zone 3'
Then I get no results, when clearly it should return 2 or 1 items 
respectfully.

This has been tested with Valentina Studio 3.2 & 3.3(most recent) on 
both mac & pc.

What am I doing wrong?

regards
alex