ok, i'm definitely showing how little i know here.
i need to select from two sets of records from a single table using an
inner join.
i can't find clear documentation on that process (a pointer would be
great).
essentially, i want to select records from the table with one WHERE
clause, then select a second set from the same table with a different
WHERE to compose a VIEW.
any help would be appreciated,
david slayton