Re: Is this query possible?

2006-08-03 Thread Tanner Postert
-Original Message- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 02, 2006 2:13 PM > To: Tanner Postert; mysql@lists.mysql.com > Subject: Re: Is this query possible? > > I'm not sure why you split out track, track is really kind of an > a

Re: Is this query possible?

2006-08-02 Thread Tanner Postert
that you want to sell. -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 2:13 PM To: Tanner Postert; mysql@lists.mysql.com Subject: Re: Is this query possible? I'm not sure why you split out track, track is really kind of an attribute

RE: Is this query possible?

2006-08-02 Thread John Meyer
have old vinyl albums around that you want to sell. -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 2:13 PM To: Tanner Postert; mysql@lists.mysql.com Subject: Re: Is this query possible? I'm not sure why you split out track, track

Re: Is this query possible?

2006-08-02 Thread Brent Baisley
I'm not sure why you split out track, track is really kind of an attribute of a song. Especially since you have artist and album with the song. Wouldn't album be the same as cd title? I'm not quite getting the logic of your schema. It would have been helpful if you provided your current query. A

RE: Is this query possible...

2003-02-19 Thread Jonathan Villa
to avoid. Thanks in advance. ---> Jonathan -Original Message- From: KH Chiu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 8:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Is this query possible... Yes. You can use INSERT INTO select from .. Reg

RE: Is this query possible...

2003-02-19 Thread Jennifer Goodie
cation is just being developed to run on two different instances. -Original Message- From: KH Chiu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 6:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Is this query possible... Yes. You can use INSERT INTO select

Re: Is this query possible...

2003-02-19 Thread KH Chiu
Yes. You can use INSERT INTO select from .. Regards, > All, > > Is this query possible to do: > > I am going to select an id from a table > > SELECT order_id FROM orders WHERE order_start = 1324 > > I will then use the order_id from this query and insert it as well as > some others valu

Re: is this query possible?

2002-06-14 Thread Erik Price
Hey, that's exactly what I needed! And I can still use WHERE clauses to further limit my results. That's great, thank you! I have one question though. In this LEFT JOIN syntax, you used the following format: LEFT JOIN secondary_table ON primary_table.col = secondary_table.col Is this optim

RE: is this query possible?

2002-06-14 Thread Jay Blanchard
[snip] I have a query that I have in mind, but am not sure of how I can actually write it. It might not even be possible. I was hoping someone could tell me if I will have to use two queries instead, or if this will actually work: (In simplified form:) ++ +---+| m

RE: is this query possible?

2002-06-14 Thread Luc Foisy
How bout SELECT main.id, sub1.other, sub2.other FROM main LEFT JOIN sub1 ON main.sub1fk = sub1.id LEFT JOIN sub2 ON main.sub2fk = sub2.id Luc mysql,sql > -Original Message- > From: Erik Price [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 3:54 PM > To: [EMAIL PROTECTED] > Su