select t.title_id,t.title,a.au_lname,a.au_fname from titleauthor ta,titles t,authors a where a.au_id=ta.au_id and t.title_id=ta.title_id
select t.*,a.au_lname,a.au_fname from titleauthor ta,titles t,authors a where a.au_id=ta.au_id and t.title_id=ta.title_id
select t.title,AUTHORNAME = a.au_fname + ' ' + a.au_lname FROM titles t LEFT JOIN (titleauthor ta LEFT JOIN authors a ON ta.au_id = a.au_id) ON t.title_id = ta.title_id 有什么不对吗?
To: CCEO() 少了一条 有书名无作者 的纪录
select t.*,a.au_lname,a.au_fname from titleauthor ta inner join titles t on ta.title_id = t.title_id left join authors a on a.au_id=ta.au_id
select t.title,AUTHORNAME = a.au_fname + ' ' + a.au_lname FROM titles t LEFT JOIN (titleauthor ta LEFT JOIN authors a ON ta.au_id = a.au_id) ON t.title_id = ta.title_id 26 ROWS. 有什么错误?清指出! TO chenbinghui: 25 ROWS
select t.title,AUTHORNAME = a.au_fname + ' ' + a.au_lname FROM titles t LEFT JOIN (titleauthor ta LEFT JOIN authors a ON ta.au_id = a.au_id) ON t.title_id = ta.title_id 我试了,查出来了,下面是结果The Busy Executive's Database Guide Marjorie Green The Busy Executive's Database Guide Abraham Bennet Cooking with Computers: Surreptitious Balance Sheets Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets Stearns MacFeather You Can Combat Computer Stress! Marjorie Green Straight Talk About Computers Dean Straight Silicon Valley Gastronomic Treats Innes del Castillo The Gourmet Microwave Michel DeFrance The Gourmet Microwave Anne Ringer But Is It User Friendly? Cheryl Carson Secrets of Silicon Valley Ann Dull Secrets of Silicon Valley Sheryl Hunter Net Etiquette Charlene Locksley Computer Phobic AND Non-Phobic Individuals: Behavior Variations Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Livia Karsen Is Anger the Enemy? Anne Ringer Is Anger the Enemy? Albert Ringer Life Without Fear Albert Ringer Prolonged Data Deprivation: Four Case Studies Johnson White Emotional Security: A New Algorithm Charlene Locksley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean Sylvia Panteley Fifty Years in Buckingham Palace Kitchens Reginald Blotchet-Halls Sushi, Anyone? Michael O'Leary Sushi, Anyone? Burt Gringlesby Sushi, Anyone? Akiko Yokomoto The Psychology of Computer Cooking NULL
SELECT t.title AS title, a.au_lname + ' ' + a.au_fname AS author FROM titles t INNER JOIN titleauthor ta ON t.title_id = ta.title_id INNER JOIN authors a ON ta.au_id = a.au_id
FROM titles t LEFT JOIN (titleauthor ta LEFT JOIN authors a ON ta.au_id = a.au_id) ON t.title_id = ta.title_id
有什么不对吗?
少了一条 有书名无作者 的纪录
inner join titles t on ta.title_id = t.title_id
left join authors a on a.au_id=ta.au_id
FROM titles t LEFT JOIN (titleauthor ta LEFT JOIN authors a ON ta.au_id = a.au_id) ON t.title_id = ta.title_id
26 ROWS.
有什么错误?清指出!
TO chenbinghui:
25 ROWS
FROM titles t LEFT JOIN (titleauthor ta LEFT JOIN authors a ON ta.au_id = a.au_id) ON t.title_id = ta.title_id
我试了,查出来了,下面是结果The Busy Executive's Database Guide Marjorie Green
The Busy Executive's Database Guide Abraham Bennet
Cooking with Computers: Surreptitious Balance Sheets Michael O'Leary
Cooking with Computers: Surreptitious Balance Sheets Stearns MacFeather
You Can Combat Computer Stress! Marjorie Green
Straight Talk About Computers Dean Straight
Silicon Valley Gastronomic Treats Innes del Castillo
The Gourmet Microwave Michel DeFrance
The Gourmet Microwave Anne Ringer
But Is It User Friendly? Cheryl Carson
Secrets of Silicon Valley Ann Dull
Secrets of Silicon Valley Sheryl Hunter
Net Etiquette Charlene Locksley
Computer Phobic AND Non-Phobic Individuals: Behavior Variations Stearns MacFeather
Computer Phobic AND Non-Phobic Individuals: Behavior Variations Livia Karsen
Is Anger the Enemy? Anne Ringer
Is Anger the Enemy? Albert Ringer
Life Without Fear Albert Ringer
Prolonged Data Deprivation: Four Case Studies Johnson White
Emotional Security: A New Algorithm Charlene Locksley
Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean Sylvia Panteley
Fifty Years in Buckingham Palace Kitchens Reginald Blotchet-Halls
Sushi, Anyone? Michael O'Leary
Sushi, Anyone? Burt Gringlesby
Sushi, Anyone? Akiko Yokomoto
The Psychology of Computer Cooking NULL
FROM titles t INNER JOIN
titleauthor ta ON t.title_id = ta.title_id INNER JOIN
authors a ON ta.au_id = a.au_id
大哥你的SQL 查询分析器和我的不一样?
我的咋不行?
这句可以执行:
回复人: lyyrw(咋暖还寒) ( ) 信誉:130 2002-12-16 15:55:00
但是这句不可以执行:
回复人: lyyrw(咋暖还寒) ( ) 信誉:130 2002-12-16 16:02:00
前一句不就是我写的?