Hi I have a small database and basically what I want to do is create a new table that combines by date the data in MailOut_Data table and CPE_Invoice_Detail so that I get an output like the NEW TABLE example. Is there a way to do it?
Please provided sample table and sample data
As we do not have access to your database
What "NEW TABLE" example??