Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> view question
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
![]() |
![]() |