A list of suppliers with the date of their first order

suppliers_with_first_orders.sql

----------------------------------------
/**
 * 
 * All suppliers that have had an order
 * raised for them.
 * 
 */
----------------------------------------	
WITH order_list AS  (
	SELECT 	
		poh.BPSNUM_0 AS [Sage Supplier #],
		bpr.BPRLOG_0 AS [Sun Supplier #],
		bpr.BPRNAM_0 AS [Supplier Name],
		bpa.BPAADDLIG_0 AS [Address Line 1],
		bpa.BPAADDLIG_1 AS [Address Line 2],
		bpa.BPAADDLIG_2 AS [Address Line 3],
		bpa.CTY_0 AS [City],
		bpa.POSCOD_0 AS [Postcode],
		CONCAT(bid.IBAN_0, bid.BIDNUM_0) AS [IBAN],
		bid.PAB1_0 AS [Swift/BIC],
		poh.CREDAT_0 AS [Order Creation Date],
		ROW_NUMBER() OVER (PARTITION BY poh.BPSNUM_0 order by poh.CREDAT_0) AS [Sequence #]
	FROM
		PORDER poh
	LEFT JOIN 
		BPARTNER bpr 
		ON 
			bpr.BPRNUM_0 = poh.BPSNUM_0
	LEFT JOIN 
		BPADDRESS bpa
		ON 
			bpa.BPANUM_0 = bpr.BPRNUM_0
	LEFT JOIN 
		BID bid 
		ON 
			bid.BPANUM_0 = bpr.BPRNUM_0
	GROUP BY 
		poh.BPSNUM_0, bpr.BPRLOG_0, bpr.BPRNAM_0, bpa.BPAADDLIG_0, bpa.BPAADDLIG_1, bpa.BPAADDLIG_2, bpa.CTY_0, bpa.POSCOD_0, bid.IBAN_0, bid.BIDNUM_0, bid.PAB1_0, bpr.CREDAT_0, poh.CREDAT_0
) 
	SELECT * FROM order_list WHERE [Sequence #] = 1