View Single Post
  #2 (permalink)  
Old April 18th, 2005, 02:25 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

In your query, you have probably joined the primary key of one table to the foreign key of the other. In design view, double-click the line joining them (take good aim; it's hard to hit) and select the join type you'd like. You probably want the second of three, but read your choices carefully.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote