Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-06 : 08:21:19
|
| Rex Cyril writes "Dear, Now we want to Avoid the duplicate records in the database.and also i don't want using the Distinct methods.using the any JOINS Queries.so display the records more than times.so pls retrieve that.Now i wrote the quries isSelect a.ID,a.Headline,a.Body,a.Visible, .CreationDate,a.Picture,a.Byline,a.OwningUser,a.PicturePhysicalPath,b.Picture1,b.PicturePhysicalPath1,b.Picture2,b.PicturePhysicalPath2,b.Picture3,b.PicturePhysicalPath3,b.Picture4,b.PicturePhysicalPath4 from NewsArticles a inner join NewPicture b on a.id='43E9732C-95E0-495C-892F-152893F9A1EA' and b.id!='43E9732C-95E0-495C-892F-152893F9A1EA'order by a.CreationDate ascDisplay the record more than once43E9732C-95E0-495C-892F-152893F9A1EA EU Propose to Amend Chapter 3 of GMP Guide and Annex 14 to Define Requirements for Dedicated Facilities for the Preparation of Medicinal Products Derived from Human Blood and Plasma EU has announced its proposals to provide more detailed guidance on the requirements for dedicated facilities for the manufacture of medicinal products derived from human blood and plasma. The concept paper, which is open for comment until 30 M 143E9732C-95E0-495C-892F-152893F9A1EA EU Propose to Amend Chapter 3 of GMP Guide and Annex 14 to Define Requirements for Dedicated Facilities for the Preparation of Medicinal Products Derived from Human Blood and Plasma EU has announced its proposals to provide more detailed guidance on the requirements for dedicated facilities for the manufacture of medicinal products derived from human blood and plasma. The concept paper, which is open for comment until 30 M 143E9732C-95E0-495C-892F-152893F9A1EA EU Propose to Amend Chapter 3 of GMP Guide and Annex 14 to Define Requirements for Dedicated Facilities for the Preparation of Medicinal Products Derived from Human Blood and Plasma EU has announced its proposals to provide more detailed guidance on the requirements for dedicated facilities for the manufacture of medicinal products derived from human blood and plasma. The concept paper, which is open for comment until 30 M 143E9732C-95E0-495C-892F-152893F9A1EA EU Propose to Amend Chapter 3 of GMP Guide and Annex 14 to Define Requirements for Dedicated Facilities for the Preparation of Medicinal Products Derived from Human Blood and Plasma EU has announced its proposals to provide more detailed guidance on the requirements for dedicated facilities for the manufacture of medicinal products derived from human blood and plasma. The concept paper, which is open for comment until 30 M 143E9732C-95E0-495C-892F-152893F9A1EA EU Propose to Amend Chapter 3 of GMP Guide and Annex 14 to Define Requirements for Dedicated Facilities for the Preparation of Medicinal Products Derived from Human Blood and Plasma EU has announced its proposals to provide more detailed guidance on the requirements for dedicated facilities for the manufacture of medicinal products derived from human blood and plasma. The concept paper, which is open for comment until 30 M 1" |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-06 : 08:25:35
|
| Left join instead of Inner join (guessing off the top of my head here) |
 |
|
|
|
|
|
|
|
how to avoid the duplicate records