i had an account on Daniweb but forgot password and recovery was a bit hectic so decided to crreate a new account. the previous username was emma etigu.
i have a problem and need some help. below i have two tables from my dataset, i would like to write an sql statement that will give me TOTAL SALES for the two tables combined. the tables contain related data derived from two different transaction processes.
these are two different tables, receiptDetails and customerReceiptDetails. i would like total quantity then total sales.