re: SubSelect Query

2002-10-03 Thread Egor Egorov
vinita, Thursday, October 03, 2002, 5:56:49 AM, you wrote: vvM> mysql> select userGroup from machineGroup_userGroups where hostname="mulga"; vvM> +---+ vvM> | userGroup | vvM> +---+ vvM> | staff | vvM> | tech | vvM> +---+ vvM> 2 rows in set (0.01 sec) vvM> mysql>

Re: subselect query

2002-04-15 Thread Christopher Thompson
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Sub-selects On Monday 15 April 2002 2:49 pm, Jeff Shipman wrote: > Yeah, that nasty thing with temporary tables and > such? Or am I looking at the wrong page? If you > could point me in the right direction, I'd

Re: subselect query

2002-04-15 Thread Jeff Shipman
Yeah, that nasty thing with temporary tables and such? Or am I looking at the wrong page? If you could point me in the right direction, I'd appreciate it (slow modem connection, etc). Christopher Thompson wrote: > Read the manual. MySQL doesn't support subselects but offers you > alternatives.

Re: subselect query

2002-04-15 Thread Christopher Thompson
Read the manual. MySQL doesn't support subselects but offers you alternatives. On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: > I'm trying to do a fairly simple select of a > column from a table where the date of that column > happens to be the highest value. I tried this: > > SELECT name