Comments by theremin

This is what I came up with and hopefully it's what's wanted... SELECT PART_NUM, DESCRIPTION, CLASS FROM PART GROUP BY CLASS ORDER BY CLASS;

Would the SQL statement for the first one look like: SELECT ORDER_NUM, ORDER_DATE, PART_NUM FROM ORDERS, ORDERS_LINE WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM IN (SELECT PART_NUM, DESCRIP...

What's the difference between ORDER BY and GROUP BY?.. besides the fact that they're different functions and spelled differently, I mean. Like, when use one and when use the other?

ok, Found out what version. "Your MySQL connection id is ***** to server version: 4.1.1-alpha-log"

Using subqueries is alright except in the case of the second problem where i wasn't supposed to use one, but we're already pass that now, so in the case of the remainder of the problems, yes, subqu...

You have all the answers. Excellent. Thanks.

So, it'd be... SELECT DISTINCT(REP_NUM, LAST_NAME, FIRST_NAME) FROM REP WHERE REP.REP_NUM = CUSTOMER.REP_NUM AND CUSTOMER.CREDIT_LIMIT = '$10,000' ?

Maybe you can tell me this... Say I have my SQL statements typed out in something.sql. Did you ever work with mySQL Control Center? 'Cause instead of running sql file via command line, I wanna t...

I think they use the word pair, because there's more than one item in each class. For example, there's not one, but 3 items in class HW (Iron, Cordless Drill, Stand Mixer)... and for some twisted ...

Thank you Ian. Every bit helps.

No, actually. haha These are my questions.

I did all the ones I could, but had trouble coming up with like the last 6 of the SQL statements required. So, I put what the database looks like, and the problems I couldn't figure out into Word....

What is a Ray Romano quote in "Welcome to Mooseport," Alex.

At least you guys aren't saying what Sigmund would've said.

<i>I</i> who MR is. You might wanna be more cryptic. j/k haha But, yeh, I know who we're talking about here, yo.

Keira Knightly is fiiine.

Meg Ryan's adorable. If she's in it, and it's an okay movie to see, I'm there everytime.

I second that! Something that should be done more often for sure!

I'm gonna eZ-msg you.

How much for a ticket? I might be interested.

Ready or not, here I come, you can't run, gonna find you, and take it slowly

It's not a grudge that I hold, Dear Sis. I'm referencing. Wo Norries

Should I be offended?

:::whispering::: {But, For the record, you have pointed out my skinniness before, in a Forum I had started about being fit.

I just love seeing how easy it is to get you all worked up. Now I know. I shall now submit these results to M.I.T. Annnd, Bob's your uncle.