SQL statement question

I need to create a custom report from using the Membership Pro database. The report needs to show a list of subscribers who paid sales tax last year. It needs to show the amount of the sales tax paid for our state. In looking at the MySQL data tables its is not apparent what tables/columns I would use to the pull the needed data. 

I will assume I am not the only person who needs to do this so this probably has been answered. Can someone help get me pointed to the right directions concerning tables and columns?

Any help is appreciated.

Hello John

I can only tell you the table is #__osmembership_subscribers. The columns you might need is created_date, tax_amount, gross_amount. Look at that table, you might need other columns, depends on your need

Regards,

Tuan

Tuan

Thanks! this at least gives me a starting place to search for the data.

John W

OK, Great.

Update - With your help I was able to track down what I needed and create the report.

Thanks again!

Great. Happy to hear that.

Tuan