Hi,
I have the following queries:
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
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
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