-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
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
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
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
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
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
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
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
[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
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
10 matches
Mail list logo