Professional Web Applications Themes

Selecting tables with relations - Microsoft SQL / MS SQL Server

Hi, I have two tables tableA and tableB. tableA: tableB: - eka - toka - name - eka - id - ope - updated The tableA is a parent table and eka is the primary key. tableB's eka is foreign key. If I do a search where tableA's eka is 4, I need to search also all rows from tableB where tableB's eka column's value is 4. And also the other way a round. If tableB's eka column value is 4 then search all rows from tableA where eka column value is 4. Hopefully somebody undestands what I want to ...

  1. #1

    Default Selecting tables with relations

    Hi,

    I have two tables tableA and tableB.

    tableA: tableB:
    - eka - toka
    - name - eka
    - id - ope
    - updated

    The tableA is a parent table and eka is the primary key.
    tableB's eka is foreign key.
    If I do a search where tableA's eka is 4, I need to search
    also all rows from tableB where tableB's eka column's value
    is 4. And also the other way a round. If tableB's eka
    column value is 4 then search all rows from tableA where eka
    column value is 4.
    Hopefully somebody undestands what I want to do. Thanks.

    ----
    mkarja
    mkarja Guest

  2. #2

    Default Re: Selecting tables with relations

    SELECT <column_list>
    FROM tableA A
    INNER JOIN TableB B
    ON A.eka = B.eka
     
    You said earlier in the post that eka is the primary key of tableA. That
    means that there can be only one row for which eka = 4.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "mkarja" <com> wrote in message
    news:google.com... 


    Jacco Guest

  3. #3

    Default Re: Selecting tables with relations

    Thanks for the help.
    The idea is that for one tableA.eka column there could be one or more
    rows where tableB.eka column value is the same as tableA.eka.

    ----
    mkarja


    "Jacco Schalkwijk" <co.uk> wrote in message news:<#phx.gbl>... 
    > You said earlier in the post that eka is the primary key of tableA. That
    > means that there can be only one row for which eka = 4.
    >
    > --
    > Jacco Schalkwijk MCDBA, MCSD, MCSE
    > Database Administrator
    > Eurostop Ltd.
    >
    >
    > "mkarja" <com> wrote in message
    > news:google.com... [/ref]
    mkarja Guest

Similar Threads

  1. selecting from two tables
    By ron1972 in forum MySQL
    Replies: 1
    Last Post: February 9th, 09:56 PM
  2. Relations in portals
    By Rans in forum FileMaker
    Replies: 2
    Last Post: November 18th, 12:37 AM
  3. Relations
    By Mago Merlino in forum IBM DB2
    Replies: 1
    Last Post: August 5th, 10:09 PM

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