Re: complicated query | no Sub query

My profound apologies here is the table create structure. the biggest problem i think is that this table does not have any primary keys or atleast unique columns: (I think joins require unique columns) mysql> show create table isr2_aud_log\G *** 1. row ***

Re: complicated query | no Sub query

Anoop kumar V <[EMAIL PROTECTED]> wrote on 05/24/2005 03:02:11 PM: > Thanks Peter - you gave me some ideas... > here is what I have so far (simplified for simplification..) > > select t2.dt_aud_rec, t1.id_secr_rqst from isr2_aud_log t1, isr2_aud_log t2 > where t1.id_secr_rqst=t2.id_secr_rqst > a

Re: complicated query | no Sub query

Thanks Peter - you gave me some ideas... here is what I have so far (simplified for simplification..) select t2.dt_aud_rec, t1.id_secr_rqst from isr2_aud_log t1, isr2_aud_log t2 where t1.id_secr_rqst=t2.id_secr_rqst and t1.dt_aud_rec > t2.dt_aud_rec group by t1.id_secr_rqst but the problem is tha

RE: complicated query | no Sub query

Anoop kumar V wrote: > well - actually it might not be the last 2 days - i just want 2 of > the latest records for every task regardless of what date it is in > the table. Okay, now I think I understand what you need - and if I am correct, this looks like one of the m

RE: complicated query | no Sub query

Anoop kumar V wrote: > 1. It returns data about only one id_secr_rqst - I want it to return > data about every id_secr_rqst in the table. So, if I understand you correctly (sorry, having a bad day), you want all records for the past two days? Assuming this, you could u

Re: complicated query | no Sub query

Thanks Peter - but I see two issues: 1. It returns data about only one id_secr_rqst - I want it to return data about every id_secr_rqst in the table. 2. Limit IMO is mysql specific (I hope I am wrong) is there something generic so I dont need to bother about which database I am running it again

RE: complicated query | no Sub query

Hi Anoop Try: SELECT t1.id_secr_rqst, t2.name_rec_type, t1.dt_aud_rec FROM isr2_aud_log t1, isr2_aud_log t2 WHERE t1.id_secr_rqst = t2.id_secr_rqst AND t1.name_rec_type='Exception Resource' ORDER by t1.dt_aud_rec DESC LIMIT 2; Peter Normann -- MySQL General Mailing List For list archives:

Re: Complicated Query

Ron Watson wrote: This works, but only if a title and a role exists for the company member. Basically, I want to display the season name from tbl Season, then the show title from tbl Shows, then the roles from cast and titles from production_team for the company member. - use LEFT JOINs. - ian

Re: Complicated query problem

>The query as written works just fine although I'm certain there's got to be >a more efficient way of doing the same thing. I'm relatively new to MySQL >so I took the brute force approach. > >My problem is that I want to produce totals of each of the columns and can't >figure out how to do it. An

Re: Complicated query. query help

* TimeWalker > I've been trying to work out a complicated query to select and > sum multiple columns in one select using a condition and multi > column group by > > > What I expected to get was ONE row with the columns summed . > > this query returns 5 rows > > SELECT sum(`AllTheWeb`),sum(

RE: Complicated Query?

* Jerry Rehak > I have a table with the columns names and id. I want to be able > to find all > names with an id of '03' that do not have other records with id values of > '10','20' or '37'. > > Is this even possible to do? > > name id > a 03 > a 11 > a 12 > a 13 I want

RE: Complicated Query?

Needs to be done programmatically -Original Message- From: Jerry Rehak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 10:53 AM To: [EMAIL PROTECTED] Subject: Complicated Query? I have a table with the columns names and id. I want to be able to find all names with an id of

Re: complicated query

try ORDER BY (Category = 'Other'), Category, Subcategory It should work, (I hope ^_-;;;) - Original Message - From: "Jeff Shipman - SysProg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 8:38 PM Subject: complicated query > I would like to do something similar

Re: complicated query

On Fri, Apr 20, 2001 at 03:09:32PM -0600, Jeff Shipman - SysProg wrote: > } > } You don't need to create another column, just use: > } > } ORDER BY category = 'other', category > } > > Are you sure this works? My query is: > > select category,subcategory from categories ORDER BY > category = 'ot

RE: complicated query

This does not work for me. It returns syntax errors. Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff On Fri, 20 Apr 2001, Braxton Robbason wrote: } you want a function that prepends the letter a to the

Re: complicated query

} } You don't need to create another column, just use: } } ORDER BY category = 'other', category } Are you sure this works? My query is: select category,subcategory from categories ORDER BY category = 'other', category; And I get: ERROR 1064: You have an error in your SQL syntax near '= 'other

Re: complicated query

On Fri, Apr 20, 2001 at 03:39:59PM -0400, Steve Werby wrote: > "Jeff Shipman - SysProg" <[EMAIL PROTECTED]> wrote: > > I would like to do something similar to an ORDER BY > > in one of my select statements, but I'mt not sure > > how to do something as complicated as this: > > > > I have two column

Re: complicated query

"Jeff Shipman - SysProg" <[EMAIL PROTECTED]> wrote: > I would like to do something similar to an ORDER BY > in one of my select statements, but I'mt not sure > how to do something as complicated as this: > > I have two columns, category and subcategory, that > I am retrieving. I would like categor

RE: complicated query

you want a function that prepends the letter a to the category/subcategory names that are not other. then you order by that function, but do not display it. select category,subcategory from foo2 order by if(category= 'other','zz',concat('a',category)); i.e. everything except other begins with an