SQL help again and again ... smh and again

I think you should donate half your salary to the tip jar.

 

Sounds like someone may have embellished their résumé.

 

I think you should get a SQL for dummies book.

 

Use DATABASE_ADMINISTRATORS
GO

Select * FROM Qualified_Candidate WHERE Name = 'Luckyazn'


(0 row(s) affected)

 

Ok, this made me laugh :grin:

 

Here you go:
http://bit.ly/LfnQCV

 

select * from clutchfans where
freetime is not null
and
username in (select username from dbas)

 

I don't get it.

I like aeroman10's suggestion.

 

A Word file is not a database and can not be queried.

 

DELETE FROM clutchfans_users u
WHERE EXISTS ( SELECT count(*)
FROM threads t
WHERE t.title LIKE '%SQL help%'
AND u.userid = t.userid );

 

Any person writing SQL knows you take all that fancy UI off of windaz. haha

It sounds like we are doing your school work for you or your work for you. There's nothing wrong with asking for help, but there are plenty of answers in a google search. Your last question regarding the reprints, was more about problem solving. That is something we can't really help you with. Either you are good at it or you aren't.

You need to give us more info when asking a question, and at least start with what you've tried or how far you've gotten.

 

If what you've told [him] is true, then you have gained my trust. (name that movie - difficulty: moderate)

 

Don't you need the "as" keyword?

 

nah, syntax looks correct to me. then again, I'm not a DBA, just someone with a development background.

 

Not for Oracle or SQL Server... Adding "as" between the object and alias is optional. Don't know specifically for MySQL, but I would assume it's the same.

 

Depend on the database.

 

Does that work?

Doesn't Count(*) just give you a number?

 

I believe the intention is to delete any user that has any thread with a title that has "sql help" in it.