(OT) Re: Bill, your computer has got a worm (virus-like thingie) Re: Sub-select look-alike?
Michael, Thank you for your alert. In the same way that you did not ask the original question, I did not write the part attributed to 'me'! There is no such address [EMAIL PROTECTED] The only address in this sub-domain subscribed to [EMAIL PROTECTED] is [EMAIL PROTECTED] I have reduced myself to list-lurker status for a number of weeks now. One of the features of the BugBear worm is that it combines components of different messages/msg-hdrs from mailing lists, and constructs its 'own' likely-looking msg/disguise to carry the viral payload for onward infection. eg yourself, my domain, and someone else, somewhere, called Bill. Vicious! Difficult to trace! The virus can be stopped at the border by most AV s/w. Its cost (apart from an actual infection) may be felt in the number of automated-response msgs that are sent out by defense mechanisms, to those they 'identify' as apparent perpetrators, who like yourself (and myself) are in fact innocent parties, and who may in turn may respond - such phenomenon will ultimately clog up the email/Internet with pointless msgs/disclaimers/refusals. You are correct, it is a Windows-only problem. You can read more details (amongst the many choices) at http:[EMAIL PROTECTED] I'm sorry you have been inconvenienced. Regards, =dn List fodder: SQL - Original Message - From: Michael Mauch [EMAIL PROTECTED] To: Bill Easton [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 6:41 PM Subject: Bill, your computer has got a worm (virus-like thingie) Re: Sub-select look-alike? Hi Bill, you wrote to me and probably several other people: If I understand your question, you just need to join with the languages table twice, using aliases: select LF.language, LT.language from language_pairs P, languages LF, languages LT where LF.id = P.from and LT.id = P.to; From: =?iso-8859-1?Q?Andreas_Fr=F8sting?= [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Date: Wed, 13 Mar 2002 I did not ask that question. Your mail had an attachment of type application/x-msdownload with the name Becks.doc.exe. This is almost certainly a worm for MS-DOS/Windows. I've got Linux, so I have no problem with this sort of things, but other recipients of your mail might be a bit upset. You should get a virus scanner with up-to-date virus signatures, and use it from a know-clean, write-protected diskette or CD. Regards... Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sub-select look-alike?
SELECT f.language as From, t.language as To FROM language f, language t, language_pairs lp WHERE f.id = lp.from AND t.id = lp.to; --Greg Johnson -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sub-select look-alike?
Is that what you want? SELECT languages.language, languages.fieldN, .., language_pairs.fieldX FROM language_pairs INNER JOIN Languages ON languages.id=language_pairs.id WHERE /* conditions */ -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sub-select look-alike?
Hi Greg, SELECT f.language as From, t.language as To FROM language f, language t, language_pairs lp WHERE f.id = lp.from AND t.id = lp.to; I really need to get some sleep I think. So simple, and yet my buggy mind didn't come up with that solution. Thanks, //andreas (sql, query - just to satisfy the filter) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub-select look-alike?
If I understand your question, you just need to join with the languages table twice, using aliases: select LF.language, LT.language from language_pairs P, languages LF, languages LT where LF.id = P.from and LT.id = P.to; From: =?iso-8859-1?Q?Andreas_Fr=F8sting?= [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Date: Wed, 13 Mar 2002 16:12:31 +0100 Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php