Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> view question

view question

From: Robert Feinman <rdf_at_admin.ccny.cuny.edu>
Date: 1997/12/07
Message-ID: <348ADD63.73B3450B@admin.ccny.cuny.edu>#1/1

I'm trying to create a view of people's names from a table which has two relevant cols: family_name, maiden_name. I want the view to search both cols and retrieve rows where either col matches, but appear to only have one col: family_name.

I've been making more a more complicated solutions with unions, etc., but I'm sure I'm overlooking something obvious. Thanks...

R. Feinman
rdf_at_admin.ccny.cuny.edu Received on Sun Dec 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US