Re: Is this query possible?

2006-08-03 Thread Tanner Postert
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 of a song. Especially since you have artist and album with the song. Wouldn't album

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.

RE: Is this query possible?

2006-08-02 Thread John Meyer
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 is really

Re: Is this query possible?

2006-08-02 Thread Tanner Postert
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 of a song. Especially

Re: Is this query possible...

2003-02-19 Thread KH Chiu
Yes. You can use INSERT INTO table 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 values I

RE: Is this query possible...

2003-02-19 Thread Jennifer Goodie
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 table select from .. Regards

RE: Is this query possible...

2003-02-19 Thread Jonathan Villa
-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 table select from .. Regards, All, Is this query possible to do: I

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]

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:) ++ +---+|

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