sql語句 嵌套查詢 排序
select *,*,* from a a left join b b on * = * order by * desc
select *,*,* from a a inner join b b on *=* order by * desc
這句話是顯示*=*的所有a的內容,上面那句話我不知道行不行,要是不行,那就要用到union了,一句話顯示*=*的所有a表內容,然后union上*不在*中的a的內容
比如:
select *,*,* from a a inner join b b on *=* order by * desc
union
select *,*,isnull(*,"無記載") as time from a a left join b b on *=* where * is null order by *
這句話我不知道對不對哦,你改改試試看