博客

SQL语句如下:

根据表中某个字段的值 来进行判断,分别查询B表或C表中的字段值。

select</p> <p> purchase.psort_Id,<br /> (case<br /> when quote_type = ‘PC’ or quote_type = ‘TD’ THEN<br /> (select purchase_title<br /> from df_purchase_demand pd<br /> where pd.ps_id = quot.master_id limit 1)<br /> when quote_type = ‘IV’ then<br /> (select inventory_Title<br /> from df_inventory dv<br /> where dv.ivt_id = quot.master_id limit 1)<br /> end) as item_title<br /> from df_quote quot<br /> left join df_purchase_demand purchase on quot.master_id = purchase.ps_id</p> <p> where 1 = 1<br /> and quot.site_Id is not null</p> <p> order by quot.create_time desc