select top 4 sheet.*,sheet_pas.pas_number,sheet_pas.pas_range from sheet,sheet_pas,sheetstate where sheet.sh_type='0C' and sheet.sh_id=sheet_pas.sh_id and sheet_pas.pas_jq='"+ssjq+"' and sheet.sh_id=sheetstate.sh_id and sheetstate.de_id='"+fdid+"'
order by sheet.sh_time
order by sheet.sh_time
and sheet.sh_id=sheet_pas.sh_id and sheet_pas.pas_jq='"+ssjq+"' and sheet.sh_id=sheetstate.sh_id and sheetstate.de_id='"+fdid+"'
where 后面多了order by 这些字母。
TRY:
select top 4 distinct sheet.*,sheet_pas.pas_number,sheet_pas.pas_range from sheet,sheet_pas,sheetstate where sheet.sh_time and sheet.sh_type='0C'
and sheet.sh_id=sheet_pas.sh_id and sheet_pas.pas_jq='"+ssjq+"' and sheet.sh_id=sheetstate.sh_id and sheetstate.de_id='"+fdid+"'
and sheet.sh_id=sheet_pas.sh_id and sheet_pas.pas_jq='"+ssjq+"' and sheet.sh_id=sheetstate.sh_id and sheetstate.de_id='"+fdid+"'
order by sheet.sh_time