Thank you Peter



-----Oprindelig meddelelse-----

Fra: Peter Foti (PeterF) [mailto:PeterF@S...]

Sendt: 13. februar 2002 17:49

Til: ASP Databases

Emne: [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').