[development] views: custom conditions using fields from multiple tables

[Roman Zimmermann]

hi,

for a site specific view I'd need to implement a view which's query
has a condition that spans multiple tables. It'll look something like:
table1.field = 'value' OR table2.field = 'other value'

Is this possible using D6/views2 ?
Am I better off just using a custom query?

thanks in advance for any pointers!

regards,
roman