Professional Web Applications Themes

An impossible question? - Microsoft SQL / MS SQL Server

BT> Background: BT> Two tables - Patients & PersonPaying BT> FName is ID key for Patients, some entries BT> "grouped"(Families) with column FamilyNo having BT> same value entered. PersonPaying has FamilyNo as BT> its ID, joined to FamilyNo in Patients, other BT> column records the FName of the person responsible BT> for paying accounts for this family. it would really help if you provided a script to create these tables. You say PersonPaying has FamilyNo as its ID, joined to FamilyNo in Patients, but then in select they are joined by Fname and Family... Vadim...

  1. #1

    Default Re: An impossible question?

    BT> Background:
    BT> Two tables - Patients & PersonPaying
    BT> FName is ID key for Patients, some entries
    BT> "grouped"(Families) with column FamilyNo having
    BT> same value entered. PersonPaying has FamilyNo as
    BT> its ID, joined to FamilyNo in Patients, other
    BT> column records the FName of the person responsible
    BT> for paying accounts for this family.

    it would really help if you provided a script to create these tables. You say

    PersonPaying has FamilyNo as its ID, joined to FamilyNo in Patients,

    but then in select they are joined by Fname and Family...


    Vadim
    Vadim Rapp Guest

  2. Moderated Post

    Default Re: An impossible question?

    Removed by Administrator
    Brett Thompson Guest
    Moderated Post

  3. #3

    Default Re: An impossible question?

    (sigh) no primary key in either table?

    no foreign keys?

    BT> Sorry, should have checked my syntax - I was
    BT> trying to be precise also as this problem bugs me!
    BT> It is Patients.FamilyNo = PersonPaying.Family

    in the table definitions that you provided, the table Patients does not have
    column FamilyNo...


    Vadim

    Vadim Rapp Guest

Similar Threads

  1. DXF - Relatively Impossible
    By Peter_Witt@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 10
    Last Post: August 31st, 05:39 PM
  2. Impossible error
    By Mjec in forum PHP Development
    Replies: 2
    Last Post: August 26th, 12:58 AM
  3. Please HELP ME, this is impossible!!!
    By Aleksandar Ciric webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 2
    Last Post: August 25th, 08:37 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139