SELECT * from account a,pay_wallet b where a.id = b.accid;
select * from account INNER JOIN pay_wallet on account.id = pay_wallet.accid;
select * from pay_wallet LEFT JOIN account on account.id = pay_wallet.accid;
SELECT * from account RIGHT JOIN pay_wallet ON account.id = pay_wallet.accid;
select * from account INNER JOIN pay_wallet ON pay_wallet.accid =(select id from account where id=12985);
select * from account where id=(select accid from pay_wallet where accid=12985);
select * from pay_wallet WHERE accid = '12985' (INNER JOIN account on account.id = pay_wallet accid);
SELECT * from pay_wallet INNER JOIN account ON pay_wallet.accid = (select id from account where id = 12985);
select * from pay_wallet where accid = 12985;
select * from pay_wallet
where accid in
(select accid from pay_wallet
where accid='12985'or accid='12956'
);
SELECT * from pay_wallet WHERE accid='12985'or accid='12956';
SELECT * from account WHERE id in (SELECT accid from pay_wallet where real_name='18011431855'or real_name='13699084054');
