SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Apr 2005
    Posts
    130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Relationship Problem with Denali

    Hi everyone,

    I am using SQL Server Denali to create 2 tables with a 1-many relationship. But I got the result of a query just like there was no relationship at all.

    Anyone please tell me if this is a bug of Denali, or there is something to do to make the relationship to work.

    Thank you.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    please show your CREATE TABLE statements, and show your query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Apr 2005
    Posts
    130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Problem solved by creating the relationship manually in query builder.

    Query builder does not show up any relationship created by CREATE TABLE statement whereas Database Diagrams does. Is there any way to get the relationships from the database to query builder?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •