[ale] Mysql joins

[maltzen at mm.com (Gary Maltzen)]

Much better solution than mine... (duh!)


> 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;


--
To unsubscribe: mail majordomo at ale.org with "unsubscribe ale" in message body.