SQL beginner question - JOIN / relational database.

[CAH]

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

[Ewoud Dronkert]

Try news:comp.databases.mysql

--
E. Dronkert

[CAH]

I will do just that, thanks for tip.

Ewoud Dronkert wrote:

Try news:comp.databases.mysql

--
E. Dronkert

[CAH]

Ewoud Dronkert wrote:

Try news:comp.databases.mysql

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

[Ewoud Dronkert]

CAH wrote:

Ewoud Dronkert wrote:

Try news:comp.databases.mysql

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.

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

[CAH]

Ewoud Dronkert wrote:

CAH wrote:

Ewoud Dronkert wrote:

Try news:comp.databases.mysql
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.

Try news:alt.comp.databases.mysql :)

ahaaa :-D
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

Thanks, for the tip and the links.

Cah