|
 |
asp_databases thread: Stored Procedure
Message #1 by "Christian Dygaard" <cdygaard@w...> on Wed, 13 Feb 2002 17:45:25 +0100
|
|
What's the error here:
CREATE PROCEDURE dbo.up_parmsel_Guestbook AS
SELECT First_Name_VC, Last_Name_VC, Favorit_Homepage_VC,
Email_Address_VC, Comment_VC, Donations_MN, Portrait_VC,
Angel_Picture_VC, In_Guestbook_BT
FROM User_T WHERE In_Guestbook_BT = 1
JOIN Angel_T ON Angel_T.Angel_ID = User_T.Angel_ID
ORDER BY Donations_MN DESC
I get the error message:
Incorrect syntax near the keyword 'JOIN'.
Regards Christian Dygaard
Message #2 by "Peter Foti (PeterF)" <PeterF@S...> on Wed, 13 Feb 2002 11:49:29 -0500
|
|
Doesn't the JOIN statement have to come before the WHERE statement?
Pete
> -----Original Message-----
> From: Christian Dygaard [mailto:cdygaard@w...]
> Sent: Wednesday, February 13, 2002 11:45 AM
> To: ASP Databases
> Subject: [asp_databases] Stored Procedure
>
>
> What's the error here:
>
> CREATE PROCEDURE dbo.up_parmsel_Guestbook AS
> SELECT First_Name_VC, Last_Name_VC, Favorit_Homepage_VC,
> Email_Address_VC, Comment_VC, Donations_MN, Portrait_VC,
> Angel_Picture_VC, In_Guestbook_BT
> FROM User_T WHERE In_Guestbook_BT = 1
> JOIN Angel_T ON Angel_T.Angel_ID = User_T.Angel_ID
> ORDER BY Donations_MN DESC
>
> I get the error message:
>
> Incorrect syntax near the keyword 'JOIN'.
>
> Regards Christian Dygaard
>
> $subst('Email.Unsub').
>
Message #3 by "Drew, Ron" <RDrew@B...> on Thu, 14 Feb 2002 08:31:50 -0500
|
|
CREATE PROCEDURE dbo.up_parmsel_Guestbook AS
SELECT First_Name_VC, Last_Name_VC, Favorit_Homepage_VC,
Email_Address_VC, Comment_VC, Donations_MN, Portrait_VC,
Angel_Picture_VC, In_Guestbook_BT
FROM User_T, Angel_T WHERE In_Guestbook_BT =3D 1
AND Angel_T.Angel_ID =3D User_T.Angel_ID
ORDER BY Donations_MN DESC
-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: Wednesday, February 13, 2002 11:49 AM
To: ASP Databases
Subject: [asp_databases] RE: Stored Procedure
Doesn't the JOIN statement have to come before the WHERE statement? Pete
> -----Original Message-----
> From: Christian Dygaard [mailto:cdygaard@w...]
> Sent: Wednesday, February 13, 2002 11:45 AM
> To: ASP Databases
> Subject: [asp_databases] Stored Procedure
>
>
> What's the error here:
>
> CREATE PROCEDURE dbo.up_parmsel_Guestbook AS
> SELECT First_Name_VC, Last_Name_VC, Favorit_Homepage_VC,
> Email_Address_VC, Comment_VC, Donations_MN, Portrait_VC,
> Angel_Picture_VC, In_Guestbook_BT
> FROM User_T WHERE In_Guestbook_BT =3D 1
> JOIN Angel_T ON Angel_T.Angel_ID =3D User_T.Angel_ID
> ORDER BY Donations_MN DESC
>
> I get the error message:
>
> Incorrect syntax near the keyword 'JOIN'.
>
> Regards Christian Dygaard
>
> $subst('Email.Unsub').
>
$subst('Email.Unsub').
Message #4 by "VAN BUTSEL ANDRE" <avanbutsel@b...> on Tue, 19 Feb 2002 22:02:14 +0100
|
|
Pete
I suppose you have to use "INNER JOIN", not "JOIN"
----- Oorspronkelijk bericht -----
Van: "Peter Foti (PeterF)" <PeterF@S...>
Aan: "ASP Databases" <asp_databases@p...>
Verzonden: woensdag 13 februari 2002 17:49
Onderwerp: [asp_databases] RE: Stored Procedure
>
> Doesn't the JOIN statement have to come before the WHERE statement?
> Pete
>
>
> > -----Original Message-----
> > From: Christian Dygaard [mailto:cdygaard@w...]
> > Sent: Wednesday, February 13, 2002 11:45 AM
> > To: ASP Databases
> > Subject: [asp_databases] Stored Procedure
> >
> >
> > What's the error here:
> >
> > CREATE PROCEDURE dbo.up_parmsel_Guestbook AS
> > SELECT First_Name_VC, Last_Name_VC, Favorit_Homepage_VC,
> > Email_Address_VC, Comment_VC, Donations_MN, Portrait_VC,
> > Angel_Picture_VC, In_Guestbook_BT
> > FROM User_T WHERE In_Guestbook_BT = 1
> > JOIN Angel_T ON Angel_T.Angel_ID = User_T.Angel_ID
> > ORDER BY Donations_MN DESC
> >
> > I get the error message:
> >
> > Incorrect syntax near the keyword 'JOIN'.
> >
> > Regards Christian Dygaard
> >
> > $subst('Email.Unsub').
> >
>
$subst('Email.Unsub').
>
|
|
|
View Cart
