i ask performance of sql. query:
select a.code ,a.name ,(select b.price b b.card = a.card , b.quote = a.quote) ,(select b.quantity b b.card = a.card , b.quote = a.quote) a.flag = '0' , a.date = '2016/09/02'
something this. performance query? slow if data big amount. how should make query more performance?
sorry poor english , in advance
try this, faster in time execute
select a.code ,a.name ,b.price ,b.quantity left join b on b.card = a.card , b.quote = a.quote a.flag = '0' , a.date = '2016/09/02
Comments
Post a Comment