any thoughts on how to compare a number field with a date field 2

[mwhalen]

where my date field is formatted to just show the year. I'm using Crystal Version 7 and I look at trying to either compare it in my SQL or in a formula straight on my report.

 

[Naith]

I had a great holiday, thanks. Hope you had a fine one yourself.

Anywho, back to this linking. Your SQL seems to be very condition heavy. That is to say there's a lot of A = X and B = Y stuff. All this will cancel out any left outer join conditions, if there's a left outer join on either A or B. This may also be the same deal in your subselects too.

It doesn't make any difference if the Visual Linking Expert does your linking or if you do it elsewhere, the links are still treated the same. If possible, you may have to think about handling some of your conditions in the FROM statement, instead of in the WHERE.

Tell you what you do, tell me what version of Oracle you're on, and show me your current SQL.

Thanks,

Naith

 

[Naith]

Oh yeah, one other thing: when you post your SQL, go on and tell me which table(s) you think should be left outer joined.

Naith

 

[mwhalen]

is it possible to email you directly? My email is mwhalen@hotmail.com - that way I can send you screen shots, etc.