SQL Syntax Error???

[munkis29]

Hey All,

I wrote this code in SQL View Query window but when I try to save it, I
get an error box that says "Syntax Error in FROM clause" I've tried a
few different variations in the syntax but still to no avail. Hopefully
someone can look this over and tell me what I'm doing wrong, thanks in
advance.

SELECT FileID FROM Test2
DECLARE @test AS int, @ctr AS int
SET @test = FileID
SET @ctr = .1

IF @test = FileID
SET FileID = FileID + ctr
SET @ctr = @ctr + .1
ELSE
SET @ctr = .1
END IF;

[Tanis]

mu******@yahoo.com wrote:

Hey All,

I wrote this code in SQL View Query window but when I try to save it, I
get an error box that says "Syntax Error in FROM clause" I've tried a
few different variations in the syntax but still to no avail. Hopefully
someone can look this over and tell me what I'm doing wrong, thanks in
advance.

SELECT FileID FROM Test2
DECLARE @test AS int, @ctr AS int
SET @test = FileID
SET @ctr = .1

IF @test = FileID
SET FileID = FileID + ctr
SET @ctr = @ctr + .1
ELSE
SET @ctr = .1
END IF;

I don't recognise much of that as SQL. In its simplest form the SQL
would look like this.

SELECT Customer.CUSTOMER
FROM Customer;

Where you are selecting the field Customer from the Customer table.
What exactly are you trying to do?