select..from..where..in..(select ... etc.)

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)

select..from..where..in..(select ... etc.)

Author

Topic

TwoEyes
Starting Member

2 Posts

Posted - 2004-02-08 : 18:09:09

Hi guys this is the problem.
php and mysql is the deal

I have this script:

UPDATE tblChecker SET Status = 'reserved', Host = '111.222.333.444', Player1 = 'Ramon'
WHERE CheckerID IN (SELECT MIN(CheckerID) FROM tblChecker WHERE Status = 'free');

Please help me with this!!!

nr
SQLTeam MVY

12543 Posts

Posted - 2004-02-08 : 19:05:25

This is a sql server forum.
You migt post it on a mysql or php forum and give a hint as to what you want help with.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-02-09 : 00:53:12

Two Eyes, what is your question. That looks like a valid T-SQL statement. The ; on the end worries me though, but I'm guessing that's from your PHP code.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

TwoEyes
Starting Member

2 Posts

Posted - 2004-02-10 : 15:36:29

quote:
Originally posted by TwoEyes

Hi guys this is the problem.
php and mysql is the deal

I have this script:

UPDATE tblChecker SET Status = 'reserved', Host = '111.222.333.444', Player1 = 'Ramon'
WHERE CheckerID IN (SELECT MIN(CheckerID) FROM tblChecker WHERE Status = 'free');

Please help me with this!!!

Hi Michael,
It's a rare problem
that's why I posted it here.
It could also be the server.
I think this sql is good.
but when i try it i get an sql erro message.
at line 2. --> the SELECT etc
strange...isn't it.

Do u have any idea what can be causing this.

Greetz TwoEyes
<0> <->

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-02-10 : 17:29:05

Have you done some tests without the subquery? the (SELECT MIN()..) part.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-02-10 : 17:35:07

quote:
Originally posted by TwoEyes

but when i try it i get an sql erro message.

OK... So what is the EXACT error message you get?

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-02-10 : 18:02:20

...and is english your native language??

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources