Hi Frank,
Frank Rust wrote:
Hi there, I'm just trying to solve a little problem:
There are two tables (simplified):
CREATE TABLE article (ID int, Title varchar, ...other_data );
CREATE TABLE author (ID int,name varchar,article_ID int,...other_data );
Now I have a lot of articles. They have one
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
]
To: mysql@lists.mysql.com
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,
`title` varchar(100) NOT NULL,
`description
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
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
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
AM
To: [EMAIL PROTECTED]
Subject: Is query possible? (Newbie)
I have 2 tables used for an online calendar...
first table fields: primary_key , start_date, event_name,
event_description second table fields: primary_key, end_date
Tables fields are shortened and can't be changed.
My second table
If I understand your question correctly, what you want is:
SELECT first_table.*, second_table.end_date
FROM first_table
LEFT JOIN second_table
ON first_table.primary_key=second_table.primary_key
cheers,
Jan
Sometime recently Grant Cooper said:
I have 2 tables used for an online calendar...
I have 2 tables used for an online calendar...
first table fields: primary_key , start_date, event_name,
event_description
second table fields: primary_key, end_date
Tables fields are shortened and can't be changed.
My second table only contains events that have a end date. I want
to
On Thursday, August 14, 2003, at 08:04 PM, Jennifer Goodie wrote:
I have 2 tables used for an online calendar...
first table fields: primary_key , start_date, event_name,
event_description
second table fields: primary_key, end_date
Tables fields are shortened and can't be changed.
My second
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
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
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
-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
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
]
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
actually work:
(In simplified form
[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:)
++
+---+|
]]
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 it. It might not even be possible. I was
hoping someone
could tell me if I will have to use two queries instead
payments as p on a.id = p.account_id
group by a.id;
Can anyone tell me what I'm doing wrong? Is this sort of query possible?
-Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
;
Can anyone tell me what I'm doing wrong? Is this sort of query possible?
Just a hunch, but the NULL columns might be screwing it up. If an account
has payments but no orders, then its sum of orders would be NULL (I think)
when you do the left join. NULL + anything = NULL.
Try replacing sum
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
21 matches
Mail list logo