All pastes #169094 Raw Edit

Miscellany

public text v1 · immutable
·published 2006-09-13 17:03 UTC
rendered paste body
SELECT count(vendorsku) FROM 

(SELECT * FROM `stock_supercom` ST, `stock_asi` SA WHERE ST.vendorsku = SA.vendorsku) as S1

JOIN

(SELECT * FROM `stock_supercom` ST, `stock_ingram` SI WHERE ST.vendorsku = SI.vendorsku) as S2

WHERE S1.vendorsku = S2.vendorsku