Joins on compound primary keys

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Shaw (jeshaw2_at_comcast.net.work)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 18:15:22 -0500

BlankUsing the query Design Grid, how does one specify a join on two tables
where the Primary Keys consist of a column with a Foreign Key and a column
with a date? MUST I go to the SQL level to do this?

Thanks

-Jim

Relevant Pages

  • Re: OReilly interview with Date
    ... >>>OK but if you have to specify the foreign key, ... I am saying that a foreign key constraint defines which values are allowed ... Kenneth Downs ...
    (comp.databases.theory)
  • Re: OReilly interview with Date
    ... >>OK but if you have to specify the foreign key, ... constraint for every join you might want to do, ... (How many other salespersons have total ...
    (comp.databases.theory)
  • Re: OReilly interview with Date
    ... >>foreign key constraints to use to generate the join? ... > Foreign keys are distiguished by suffix and prefix, ... OK but if you have to specify the foreign key, ...
    (comp.databases.theory)
  • Re: ORA-00905: missing keyword Need advice
    ... You do not specify which column in Course you reference. ... FOREIGN KEY REFERENCES Course ... When you specify a foreign key constraint inline, ...
    (comp.databases.oracle.misc)