BUG: Automatic Joining Only Joins Two Tables (184575)
The information in this article applies to:
- Microsoft Visual Database Tools
This article was previously published under Q184575 SYMPTOMS
The Query Designer creates only one join based on columns with the same
name and data type. If more than one join is possible, the Query Designer
stops after creating the first join.
STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed
at the beginning of this article. We are researching this bug and will post
new information here in the Microsoft Knowledge Base as it becomes
available.
MORE INFORMATIONSteps to Reproduce Behavior
The user drags in three tables. A is related to B, and B is related to C.
Query Designer finds the join between a single pair of tables, then stops.
REFERENCES
See the InfoViewer topic: Microsoft Visual Database Tools/Query Designer/
Querying using multiple tables/Joining tables automatically
Modification Type: | Minor | Last Reviewed: | 8/18/2005 |
---|
Keywords: | kbbug kbDtQDesigner kbnofix KB184575 |
---|
|