Howabout
select record.* from record left join user on
user.account=record.account where user.username='george';
Since there is no table name "account"
>select record.* from record left join account on
>account.username=record.account where account.username='george'
>
> >SELECT account FROM user where username = 'george';
> >then using the result from this query,
> >i pass it onto the next:
> >
> >SELECT * FROM record WHERE account = 'result from above';
> >
> >I am new to 'JOIN' and dont know the correct join syntax.
> >
> >THANKS,
> >jaime
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
