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