下面是我自己一個數据庫的查詢,除了表名字不同,其他一樣的呀.. SELECT * FROM tbl_account INNER JOIN tbl_account_detail ON tbl_account.account_id=tbl_account_detail.account_id WHERE tbl_account_detail.account_id like '*01';
你可以用别名,如 select poem.name AS PNAME weiter.NAME AS WNAME from poem inner join writer on poem.???=weiter.??? where writer.name like '*邦'" 可以看一些SQL语言方面的书,很容易的
select * from poem inner join writer on poem.???=weiter.??? where writer.name like '*邦'"
SELECT *
FROM tbl_account INNER JOIN tbl_account_detail ON tbl_account.account_id=tbl_account_detail.account_id
WHERE tbl_account_detail.account_id like '*01';
select poem.name AS PNAME weiter.NAME AS WNAME from poem inner join writer on poem.???=weiter.??? where writer.name like '*邦'"
可以看一些SQL语言方面的书,很容易的