[ale] Mysql joins

[David Corbin]

you want to *databases*, or tables?  In the first case, you need to
explain more.
In the second, I think I understand.  Here is a solution (in pseudo
code-diagram)

USER
====
id Number
login VARCHAR(30)
name  VARCHAR(50)

SITE
====
url VARCHAR(500)
user_id NUMBER

Then you can do this:
SELECT login,name,url from USER,SITE WHERE SITE.USER_ID=USER.ID;


Ken N wrote:
> 
> Hi,
>         There's alot of good sql people here so I thought I might ask for
> some direction before I start this thing. I want to have two databases,
> One with a username and real name and two with web sites listed. See if
> there was only one table I would have to have a repeat username and
> reallname for website the person has. See my point? So I am thinking I
> will need to join from two tables.
>         What i was wondering is how do I do set up the tables? I would
> need like a primary key or something? Hmm, if anyone has anysuggestions I
> am open to them cause I really haven't done much with SQL before.
> 
> Thanks
> Ken N
> 
> http://cleveland.lug.net/~rocket/
> 
> The answer is simple if you grant that ironies are like submarines;
> dangerous only when submerged.
> 
> --
> To unsubscribe: mail majordomo at ale.org with "unsubscribe ale" in message body.

-- 
David Corbin 		
Mach Turtle Technologies, Inc.
http://www.machturtle.com
dcorbin at machturtle.com
--
To unsubscribe: mail majordomo at ale.org with "unsubscribe ale" in message body.