Comments by iwz

looks good to me.

on the subquery, you want to select the ORDER_NUM, not the PART_NUM.

looks like you've got the right idea. i might modify it like this tho: SELECT ORDER_NUM, ORDER_DATE, PART_NUM FROM ORDERS, ORDERS_LINE WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM AND O...

looks right to me. http://www.mysql.com/doc/en/CREATE_TABLE.html

good question. it's called string escaping. read about it here: http://www.mysql.com/doc/en/String_syntax.html and, basically it would be 'theremin\'s' just put a \ in front of the '

some of the things in there seem to require more than 1 query, such as the first one, and the last one. what version of mysql are you doing this on? 4.1 supports subqueries, but 4.0 doesn't. do ...

looks pretty good to me.

it's easy. since you're all setup already, just login, go to the database, and click on the SQL button on the toolbar. then you can type in sql or open up a .sql file.

question 3 is confusing, because it mentions parts are in "pairs", and I don't see how they are paired at all. I don't really understand the question. But, maybe what they're looking for is a GROUP...

Ok, well for #2 on that page.. you basically want to join the REP and CUSTOMER tables on the REP_NUM column, and also CUSTOMER.CREDIT_LIMIT = '$10,000.00'. Then just add in the DISTINCT keyword ...

odd. i'm listening to reggae right now.

hey, you don't have to put anchor tags around links. just post the url, ezabel turns it into a link.

or, conversely, he designed the universe and physical materials in a way to perfectly befit beings made in his image.

We've already had this poll, but it's probably ok to do again. http://www.ezabel.com/comments.cfm?type=poll&id=104

dude, was this really a dream? ahah. wow. so that's how you see me?

here's mine: http://www.looroll.com/thesheets/wallpapers/paperview.php3?paperview=number/0018

have you seen some of the cases you can get now? so awesome. they look like actual electronics devices. the shuttles are very nice too. you should definitely set it up so that you have 2 tv t...

whoops. I was wrong. Mixed it up with F-Zero GX I guess. I saw Viewtiful Joe for $20 used the other day though. Anyway, here's what i was talking about http://www.planetgamecube.com/news.cfm?ac...

viewtiful joe is coming down to $20 too, nintendo player's choice.

nice!! using mythtv?

come on, you have all the geeks foaming at the mouth now. ask your question bro haha

yeah, that could be true. makes sense to me. if in doubt, read the stuff, or check with an accountant.

yeah, pioneers can claim that. also, 50% of money spent on meals in the ministry.

yeah i went to see cats right before it left theaters. we left during intermission. ugh it was lame.

misreply, sorry