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

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