--- nocturno@stripped wrote:
> I need a little help querying 2 tables in MySQL;
>
> Table User
> User_Id // Id = 2
> User_Name // John
>
> Table History
> User_Id // 2
> User_History // John has born in 58
>
> SELECT User_History FROM History WHERE User_Id = 2; // return John has
> born in 58
>
> But what my SELECT should look if i don't know the user id and want search
> the User_History by the User_Name?
>
> SELECT User_History FROM History WHERE User_Id = ( SOMEWAY TO DATABASE FIND
> JOHN ID BY JOHN NAME )
I am no MySQL expert by any means, but I believe that a sub select would handle
it. However, last I knew MySQL didn't support them. So I believe the other
solution would be to do a JOIN, I thought I remembered people here saying that
JOINs are the sub-select work around. Seeing as how I do not know them at all I
can't offer an example... Sorry
If this is incorrect someone please correct me.
Thanx,
Ryan
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
