PDA

View Full Version : SQL export query for Sebenza Points


kyle
02-13-07, 08:57 PM
I'm using the sebenza points module and want to be able to export that data on the customers. does anyone have knowledge about how to export this data, what needs to be done?
Thanks
--Kyle

Brandon MUS
02-13-07, 09:35 PM
What details do you need exported? Customer name, email and points?
SELECT
CONCAT(s01_Customers.ship_fname, ' ', s01_Customers.ship_lname) AS ship_fullname
, s01_Customers.ship_email
, s01_SS_POINTS_cust.total
FROM
s01_Customers
INNER JOIN
s01_SS_POINTS_cust
ON
s01_Customers.id = s01_SS_POINTS_cust.cust_id