SQL beginner question - JOIN / relational database.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • CAH
    #1

    SQL beginner question - JOIN / relational database.

    Hi

    I am going to make two tables that each have a Priamary ID called User
    ID, and they should relate two one another. Do i have to make this
    clear when building the tables, or should I just give them the same
    Coloum name, and then retrive data from the two tables with some kind
    of JOIN call?

    Thanks for any help.

    Cah

    Tags: None
    • Ewoud Dronkert
      #2
      Re: SQL beginner question - JOIN / relational database.

      Try news:comp.datab ases.mysql

      --
      E. Dronkert

        Comment

        • CAH
          #3
          Re: SQL beginner question - JOIN / relational database.

          I will do just that, thanks for tip.

          Ewoud Dronkert wrote:[color=blue]
          > Try news:comp.datab ases.mysql
          >
          > --
          > E. Dronkert[/color]

            Comment

            • CAH
              #4
              Re: SQL beginner question - JOIN / relational database.


              Ewoud Dronkert wrote:[color=blue]
              > Try news:comp.datab ases.mysql[/color]

              Sorry can not do just that, my internet provider does not list it as
              yet. So if anybody knows the answer, ill apreciate a posting here.

              Cah

                Comment

                • Ewoud Dronkert
                  #5
                  Re: SQL beginner question - JOIN / relational database.

                  CAH wrote:[color=blue]
                  > Ewoud Dronkert wrote:[color=green]
                  >> Try news:comp.datab ases.mysql[/color]
                  >
                  > Sorry can not do just that, my internet provider does not list it as
                  > yet. So if anybody knows the answer, ill apreciate a posting here.[/color]

                  Try news:alt.comp.d atabases.mysql :)

                  If the columns have the same name, a JOIN without ON clause will do. No
                  need to define anything beforehand, unless you want to have the db keep
                  track of referential integrity. Also see
                  fw_error_www
                  http://dev.mysql.com/doc/mysql/en/example-foreign-keys.html


                  --
                  E. Dronkert

                    Comment

                    • CAH
                      #6
                      Re: SQL beginner question - JOIN / relational database.


                      Ewoud Dronkert wrote:[color=blue]
                      > CAH wrote:[color=green]
                      > > Ewoud Dronkert wrote:[color=darkred]
                      > >> Try news:comp.datab ases.mysql[/color]
                      > >
                      > > Sorry can not do just that, my internet provider does not list it as
                      > > yet. So if anybody knows the answer, ill apreciate a posting here.[/color]
                      >
                      > Try news:alt.comp.d atabases.mysql :)[/color]

                      ahaaa :-D
                      [color=blue]
                      > If the columns have the same name, a JOIN without ON clause will do. No
                      > need to define anything beforehand, unless you want to have the db keep
                      > track of referential integrity. Also see
                      > http://dev.mysql.com/doc/mysql/en/ex...eign-keys.html[/color]

                      Thanks, for the tip and the links.

                      Cah

                        Comment

                        Previous template Next
                        Working...