Hi Shawn:
Just wanted to publicly thank you for the time you took to help me. I think
that it is important that guys like yourself who take time out from your busy
work be appreciated when their solution made a huge difference.
I was developing an ASP application along with Crystal reports for
;
> best regards
> Imran
>
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Imran" <[EMAIL PROTECTED]>
> Cc:
> Sent: Tuesday, October 11, 2005 11:33 AM
> Subject: Re: Help on writing a sql statement
>
>
&g
ay, October 11, 2005 11:33 AM
Subject: Re: Help on writing a sql statement
> Will you have name collisions with the same temporary table names used
> from different connections? Nope.
>
> Temporary tables and user-defined (@-variables) are connection-specific.
> Even if the same use
> table will exist already exist
>
>
> best regards
> Imran.
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Imran" <[EMAIL PROTECTED]>
> Cc:
> Sent: Tuesday, October 11, 2005 9:49 AM
> Subject: Re: Help on writing
ay, October 11, 2005 9:49 AM
Subject: Re: Help on writing a sql statement
> (my response bottom-posted. See below - SG)
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: "Imran" <[EMAIL PROTECTED]>
> > Cc:
> > Sent: Mond
eport` int(10) default NULL,
> PRIMARY KEY (`ID`),
> KEY `ProdNo` (`ProdNo`),
> KEY `Branch` (`Branch`)
> )
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Imran" <[EMAIL PROTECTED]>
> Cc:
> Sent: Monday, October 10, 2005 4
l Message -
From: <[EMAIL PROTECTED]>
To: "Imran" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 10, 2005 4:17 PM
Subject: Re: Help on writing a sql statement
> "Imran" <[EMAIL PROTECTED]> wrote on 10/10/2005 03:52:21 PM:
>
> > Hi all:
> > I
"Imran" <[EMAIL PROTECTED]> wrote on 10/10/2005 03:52:21 PM:
> Hi all:
> I need some help in writing a sql statement.
>
> I have three tables (Sales, Cust and Product). The sales table contains
a
> large volume of data and I want to create a sql to group the sales table
> then join the resultant
Hi all:
I need some help in writing a sql statement.
I have three tables (Sales, Cust and Product). The sales table contains a
large volume of data and I want to create a sql to group the sales table
then join the resultant to both the Cust and Prod and to have additional
fields selected fr
