error= select sd.seg_id,ss.seg_name,sd.aired_date,ss.vdo_file,ss.synopsis,ss.title from show_date as sd join show_segment as ss where sd.seg_id=ss.id and sd.aired_date='2010-03-11'