create table DATA (IMAGE_ID ,IMAGETimestamp, IMAGEFilePath ); create table FRAME(FrameID,VideoStartTime, VideoEndTime,VideoFile path);
here the Image id is primary key and frame ID is foreign key
i want to join the tables in such a way that FrameID did not come in the joined table as the entries of the Imageid and frame id are same i applied the query by left outer join but it is huge can someone help to reduce the size...
select DATA.Img_ID,DATA.Img_Type,DATA.Img_FilePath,DATA.Img_TimeStamp,DATA.Img_Lat,DATA.Img_long,DATA.Img_Country,DATA.Img_City,DATA.Img_Landmark, DATA.MPEG7FILEPATH,DATA.Img_Title,DATA.Img_Creator,DATA.Img_Description,DATA.Img_Keyword,DATA.Img_Genre,DATA.Img_Rate,DATA.Img_Copyright, FRAME.VIDEOSTARTTIME,FRAME.VIDEOENDTIME,FRAME.VIDEOFILEPATH from DATA left join FRAME on DATA.Img_ID=FRAME.FRAMEID;
This post has been edited by baavgai: 26 July 2012 - 05:36 AM
Reason for edit:: tagged. Didn't really help.