Are you looking for something like this?
select * from [2013_11_call_detail_record] cdr JOIN [2013_11_csi_appdata] ap ON ap.APP_LOG_ID = cdr.APP_LOG_ID JOIN [2013_11_csi_appdata_ext] ext ON ext.APP_LOG_ID = cdr.APP_LOG_ID JOIN [2013_11_csi_checkpoint] chk ON chk.APP_LOG_ID = cdr.APP_LOG_ID where user_defined_fld3 = 'asrnt' and call_start_tstamp >= '11/15/2013' and call_start_tstamp < '11/18/2013'
You wouldn't need to do a UNION ALL, just change your date range.
Thanks for the quick response Dallin, but no success yet. I keep getting this error....
[Microsoft][ODBC SQL Server Driver][SQL Server]The column 'SOURCE_SERVER' was specified multiple times for 'TableauSQL'.
OK, I think you need to define each of the fields you want to pull in separately in your SELECT statement instead of using * because there are multiple columns with the same name across your different tables.
Ahhh...Yes makes sense. Thanks