Database

BrunoPigeon wrote:

I am new to SQL and am trying to learn, hence asking on this forum.

Select 
    distinct format(SupplierInvoices.Date, 'dd-MMM-yyyy') as tDate, 
    Sum(SupplierInvoices.QTY) as lTotal 
from SupplierInvoices 
where PLU = '" & lblPLU.Caption & "' 
    and Date Between #" & StartTime & "# and #" & EndTime & "# 
Group by format(SupplierInvoices.Date, 'dd-MMM-yyyy') 
Union 
Select 
    distinct format(Sales.Date, 'dd-MMM-yyyy') as tDate, 
    Sum(Sales.QTY) as sTotal 
from Sales 
where PLU = '" & lblPLU.Caption & "' 
    and Date Between #" & StartTime & "# and #" & EndTime & "# 
Group by format(Sales.Date, 'dd-MMM-yyyy')

NGAYGIAO BETWEEN #01/01/2019# AND #31/01/2019#

for (int i = 0; i < [Original data].Count; i++)
            { 
                bool BOOLEAN = 0;
                string SOHD = "";
                if([NGAYGIAO].[i]>=#1/1/2019# && [NGAYGIAO].[i] <=#1/31/2019#) //dd/MM/yyyy
                {
                   for (int j = 0; j < [Original data].Count; j++)
                   {
                       if([LOAIHD].[j] == "FBAN") 
                        {
                            BOOLEAN = 1;
                            SOHD = [Original data].[HD].[j];
                        }<br />
                   }
                }
                if(SOHD == [Original data].[HD].[i] && SOHD != "")
                {
                    [Result].[BOOL].[i] = BOOLEAN;
                }
            }

Kevin Marois wrote:

provider: Named Pipes Provider

Kevin Marois wrote:

For some reason I can no longer connect.

Member 14182925 wrote:

what should it be normalised to.

Member 14182925 wrote:

The detailed process of implementing the database using SQL

Member 14182925 wrote:

including the normalisation of the table (should that be required),

Member 14182925 wrote:

and the use of SQL commands in order to create and populate the tables with data

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Member 14182925 wrote:

If you're willing to help