All pastes #169097 Raw Edit

Mine

public text v1 · immutable
·published 2006-09-13 17:08 UTC
rendered paste body
SELECT count(vendorsku) FROM 
(
(SELECT ST.vendorsku FROM `stock_supercom` ST, `stock_asi` SA WHERE ST.vendorsku = SA.vendorsku) 

UNION

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

UNION

(SELECT SA.vendorsku FROM `stock_asi` SA, `stock_ingram` SI WHERE SA.vendorsku = SI.vendorsku)
) as FT

WHERE 1