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
From: "Tanner Postert" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 01, 2006 8:21 PM Subject: Is this query possible? ok, here is the schema that I am working with: CREATE TABLE `cd` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL, `tit

Is this query possible?

2006-08-01 Thread Tanner Postert
ok, here is the schema that I am working with: CREATE TABLE `cd` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL, `title` varchar(100) NOT NULL, `description` text NOT NULL, `dt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CREATE TABLE `song

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

Is this query possible...

2003-02-19 Thread Jonathan Villa
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 have into another table. So in summary, I want to perform a SELECT and

Re: is this query possible?

2002-06-14 Thread Erik Price
inal Message- >> From: Erik Price [mailto:[EMAIL PROTECTED]] >> Sent: Friday, June 14, 2002 3:54 PM >> To: [EMAIL PROTECTED] >> Subject: is this query possible? >> >> >> I have a query that I have in mind, but am not sure of how I can >> actually write

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
IL PROTECTED] > Subject: is this query possible? > > > 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

is this query possible?

2002-06-14 Thread Erik Price
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:) ++ +---+| main

RE: Left join? Is this query possible.

2001-08-15 Thread Philip Mak
On Thu, 16 Aug 2001, Rodney Moses wrote: > Thanks for the reply Philip! > > Unfortunately that doesn't work. I should have clarified that there never > are null values in the 'amount' fields. Even if you don't have NULL values in the 'amount' fields, doing the LEFT JOIN will cause NULL values to

RE: Left join? Is this query possible.

2001-08-15 Thread Rodney Moses
Thanks for the reply Philip! Unfortunately that doesn't work. I should have clarified that there never are null values in the 'amount' fields. Maybe it is wrong to join both the payment and the order tables to the account table in the query as neither of these directly related to eachother. On

Re: Left join? Is this query possible.

2001-08-15 Thread Philip Mak
On Thu, 16 Aug 2001, Rodney Moses wrote: > This doesn't work, it has really wacky results: > #balance of all accounts > select a.id, (sum(o.amount) - sum(p.amount)) from > accounts as a left join orders as o on a.id = o.account_id left join > payments as p on a.id = p.account_id > group by a.

Left join? Is this query possible.

2001-08-15 Thread Rodney Moses
Hi, This is probably not the right forum for this question, sorry, I'm really stuck... I need to write a query for an e-commerce system that calculates account balances. With the current database structure I can write two separate queries, one to get the sum of all payments and one to get the sum