<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">This should be in the Support list.</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">I believe using the "Relationship" stuff would allow this, but you may have to build a module to provide that information. In which case, doing your own query is probably faster.<VAR id=yui-ie-cursor></VAR></SPAN></div>
<DIV></DIV>
<DIV style="RIGHT: auto"> </DIV>
<div style="RIGHT: auto"><FONT color=#ff007f size=4 face="bookman old style, new york, times, serif"><I><STRONG>Nancy</STRONG></I></FONT></div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto"><FONT style="RIGHT: auto" face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></div>
<div style="RIGHT: auto"><BR style="RIGHT: auto">
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; RIGHT: auto">
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><FONT size=2 face=Arial>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class=hr readonly="true" contenteditable="false"></DIV></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Roman Zimmermann</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"></FONT><BR>for a site specific view I'd need to implement a view which's query<BR>has a condition that spans multiple tables. It'll look something like:<BR>table1.field = 'value' OR table2.field = 'other value'<BR><BR>Is this possible using D6/views2 ?<BR>Am I better off just using a custom query?</DIV></DIV></BLOCKQUOTE></div></div></body></html>