Not in or join problem

[tedi1]

Hi,

I want to to link two SQL Server tables by outer join but for some strange reson The option of changing the type of join is graed out, Why?
Because this didn't work I have tried to use not ... in ... but this didn't work either. The formula I have used is:
not ({orders.compId} in [{BankAccount.compId}])

I'm useing CR 8.5 on W2K

 

[synapsevampire]

Are these tables in the same database?

Are you using the correct connectivity?

If so, this should work.

-k

 

[tedi1]

Hi,

The tables are coming from two different DB. The Auto link does link between the two tables but the link is just an Equal Link and there is no other linkage option.
Why, if the not Equal linkage cannot work, doesn't the Not in working?

 

[lyanch]

Crystal does not let you change the join between servers. It only lets you change the link if they are different DB's on the *same* server.

Lisa