Yes, it can be written with a subquery. But in some cases, that can be slower. In this assignment though, either way will work. I doubt the teacher expects anyone to be an SQL expert.
When it...
Search:
Type: Posts; User: ajaxer
Search: Search took 0.00 seconds.
- 27 Mar. 2013, 05:03pm
Thread: My web programming class
by ajaxer- Replies
- 26
- Views
- 1,224
Yes, it can be written with a subquery. But in...
- 27 Mar. 2013, 12:03am
Thread: My web programming class
by ajaxer- Replies
- 26
- Views
- 1,224
I hated doing work in groups. Someone has to...
I hated doing work in groups. Someone has to keep on top of things for everyone, and make sure that they're doing what they're supposed to. It's so much easier to do things in 2s, or by yourself. ...
- 26 Mar. 2013, 11:52pm
Thread: My web programming class
by ajaxer- Replies
- 26
- Views
- 1,224
Also, 3 weeks seems like a pretty tight deadline...
Also, 3 weeks seems like a pretty tight deadline for all that functionality. That must be some pretty bare bones UI.
- 26 Mar. 2013, 11:50pm
Thread: My web programming class
by ajaxer- Replies
- 26
- Views
- 1,224
That's not correct. You don't need 30 queries to...
That's not correct. You don't need 30 queries to get the list of 30 friends. You just need 2 queries.
That's what the 'IN' operator is for.
get the list of user ids:
SELECT recipientId FROM...
Results 1 to 4 of 4