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

.



Relevant Pages

  • Andersen Winches
    ... Winches. ... But you can probaly use it for others aswell. ... Cah ... Prev by Date: ...
    (rec.boats.cruising)
  • Re: batter goofing off at the plate
    ... >>Tiger third-baseman Nor Cah ... >Norm Cash, actually... ... First baseman, actually :-) ... Prev by Date: ...
    (rec.sport.baseball)
  • RE: need help with lookup
    ... > first tree characters in coloum A and return the value of it (here, ... > where as I would like to get wall ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Include in conditional does not work - why?
    ... Is this the best php group for this sort of question? ... CAH ... Prev by Date: ...
    (comp.lang.php)
  • subtotal on each page
    ... page of the report, but I would like to have the subtotal of each coloum for ... at then end of page 1 each colum would have a total of 100 ... Page two would have a total for each coloum of 100 ... Prev by Date: ...
    (microsoft.public.access.reports)