All pastes #169100 Raw Edit

Miscellany

public text v1 · immutable
·published 2006-09-13 17:11 UTC
rendered paste body
SELECT count(vendorsku) FROM 
(
SELECT 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 TT

GROUP BY vendorsku
) as FT