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

re: SQL beginner question - JOIN / relational database.

Try news:comp.databases.mysql

--
E. Dronkert

re: SQL beginner question - JOIN / relational database.

I will do just that, thanks for tip.

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

re: SQL beginner question - JOIN / relational database.

Ewoud Dronkert wrote:[color=blue]
> Try news:comp.databases.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

re: SQL beginner question - JOIN / relational database.

CAH wrote:[color=blue]
> Ewoud Dronkert wrote:[color=green]
>> Try news:comp.databases.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.databases.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
http://dev.mysql.com/doc/mysql/en/ex...eign-keys.html

--
E. Dronkert

re: SQL beginner question - JOIN / relational database.

Ewoud Dronkert wrote:[color=blue]
> CAH wrote:[color=green]
> > Ewoud Dronkert wrote:[color=darkred]
> >> Try news:comp.databases.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.databases.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