Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 I just can't see

Author  Topic 

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2003-01-06 : 04:31:36
Maybe I am just too tired to be doing this right now but I just can't get this code to work. I get an error "Incorrect syntax near the keyword 'where'." Anyone have any ideas? I looked over my books and can see anything.

Code:
select * from moves inner join knownmoves where movename = move and movelevel = movelevel

--
For those with wings, fly to your dreams

It is all or nothing there is no in-between

Remember who I was... For me

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2003-01-06 : 04:34:26
You probably are.

select * from
moves inner join
knownmoves ON moves.xx = knownmoves.xx
where movename = move and movelevel = movelevel

Get some sleep...

Go to Top of Page

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2003-01-06 : 04:39:01
GOD! How the heck did I do that? I will be going to sleep now and continue the work in the morning. Thanks for the help (and advice)

--
For those with wings, fly to your dreams

It is all or nothing there is no in-between

Remember who I was... For me
Go to Top of Page
   

- Advertisement -