i want to get unique data among two tables

Question

from two tables i want like albumnamecreated datecreated byand first imginfo from albinfo tabel..please help me...

Pravat Kumar · Answer

select AlbumNamedatecreatedByimgInfo from(select ai.AlbumNamedatecreatedByimgInfo ROW_NUMBER() OVER ( PARTITION BY ai.AlbumName ORDER BY Date ) AS RowNumber from AlbInfo ai JOIN Upload u ON ai.AlbumName=u.AlbumName)x where RowNumber=1

Khaja Moizuddin · Answer

You can use joins concept like inner join to perform your operation...

Nitin Sontakke · Answer

Just in case it is not clear to you Ananth has given a solution to you which is sorting image file name alphabetically and taking the top one as a first one.

Ananth G · Answer

Select a.Albumnamea.CreatedBya. Date b.Descriptionb.ImgInfo from SecondTable a left join ( SELECT AlbumName max (ImgInfo) as ImgInfo FROM FirstTable group by AlbumName) b on a. Albumname=b. Albumname ;

Nitin Sontakke · Answer

On what basis you are saying first image. That is very important. If you had date time column in that table it is simple. There must be some criteria to identity first image for every album.

Ananth G · Answer

Table1 have Id or not?

SreeRam Kondagorla · Answer

if i have date time column column then how can i get that please tell me..thanks...

Nitin Sontakke · Answer

Got it. But do you have a DateTime column or just the Date column. If you only have Date column which has no time in it it will be very difficult.

SreeRam Kondagorla · Answer

Hi Sir...please check that i want album nameand first image of that album and created datecreated by only...thanks

Nitin Sontakke · Answer

Looks good to me. Are you getting expected result? If not please post what you expect.

SreeRam Kondagorla · Answer

please check my code...

Ananth G · Answer

Select a.Albumnamea.ImgInfob.CreatedByb.Date from FirstTable a left join SecondTable b on a.AlbumName= b.AlbumName Used above query

Nitin Sontakke · Answer

AlbumName is the common column here...so your query would be: select * from albinfo ai left outer join imginfo ii on ii.AlbumName = ai.AlbumName Hope it helps. In case of any more questions please ping back.