Hi Guys,

I have ARI Data Tables installed and configured, but I'm having some troubles creating the SQL queries I need to generate a few reports.

I can get a string to show me data from one table, but I can't seem to create a statement that pulls information from two tables. The final issue is doing a little math on the data to have it display only records that fall within a certain date range. Here's two examples of what we are trying to do.

Can anyone help build these queries? Many Thanks!

New Members
Filter: members with a new subscription since a date we input. (If we can't have an input field, then the filter should be for a subscription any date within the current month.)
Display: userid, name, subscription(s), subscription date(s).

Modified Member Data
Filter: members with modified data in any field except subscription fields since a date we input. (example: we're looking for someone who changed their address, phone, etc.)
Display: userid, any field that was modified.

Thanks again!

Hello,

It is possible to use JOIN construction to merge data from several tables.

Regards,
ARI Soft