---
From: Michael Collins [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 05:14
To: [EMAIL PROTECTED]
Subject: sql join help
I suppose this would be easier with subselects but I am using MySQL 4:
I want all orders that are of orderStatus 2 and whose orderitems
contain a product that is in a productparent
ems that have no associated order?
The above should do what you state below, though - I think!
Cheers,
Matt
-Original Message-
From: Michael Collins [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 05:14
To: [EMAIL PROTECTED]
Subject: sql join help
I suppose this would be easier w
I suppose this would be easier with subselects but I am using MySQL 4:
I want all orders that are of orderStatus 2 and whose orderitems
contain a product that is in a productparent category greater than 2.
An orderitem can only have one product, and that product has a single
certain product par
Multiple table update is only supported from 4.04 or above. If you are using
3.x, I think you should put the result into another table, delete MSI_List
and rename the table to MSI_List.
I would also very interested to know whether there exist a more elegant
solution for 3.x.
Best regards,
> s
sql
I have a zip code db named "MSI_Zipcodes that contains
city
state
zipcode (index)
I also have a db named "MSI_List" that contains
ID (index)
email
city(empty)
state(empty)
zip
My problem is:
How can i bring the proper info from "MSI_Zipcodes"(city and state)
and enter it (city and state)
I figured it out ...
At 3:22 PM +0100 5/20/02, ds wrote:
>On Mon, 2002-05-20 at 13:34, Ray Zimmerman wrote:
>...
> > For example, given the following data ...
>>
>> CREATE TABLE Object (
>> id int(11) NOT NULL auto_increment,
>> PRIMARY KEY (id)
>> );
>>
>> INSERT INTO O
On Mon, 2002-05-20 at 13:34, Ray Zimmerman wrote:
...
> For example, given the following data ...
>
>CREATE TABLE Object (
> id int(11) NOT NULL auto_increment,
> PRIMARY KEY (id)
>);
>
>INSERT INTO Object (id) VALUES (1);
>INSERT INTO Object (id) VALUES (2);
>INSE
Dear list,
I've done basic SQL for a number of years, but I recently came up
against a query I can't quite seem to figure out the join syntax for.
Suppose I have rows in an Object table which are linked in a
hierarchy by the entries in a Link table and I want to find all
Objects which have gi
: Probably OT - SQL join help needed
Hello Robert,
> Hello experts, I've got a small problem with an sql query
here that's got
> me completely stuck.
>
> In my MySQL database I've got two tables here
Hello experts, I've got a small problem with an sql query here that's got
me completely stuck.
In my MySQL database I've got two tables here that have identical design,
e.g.
table 'detail' - columns sales-order, quantity, part-number, price,
date-sent
and
table 'archived' - columns sales-order,
Hello Robert,
> Hello experts, I've got a small problem with an sql query here that's got
> me completely stuck.
>
> In my MySQL database I've got two tables here that have identical design,
> e.g.
> table 'detail' - columns sales-order, quantity, part-number, price,
> date-sent
> and
> table 'ar
Hello experts, I've got a small problem with an sql query here that's got
me completely stuck.
In my MySQL database I've got two tables here that have identical design,
e.g.
table 'detail' - columns sales-order, quantity, part-number, price,
date-sent
and
table 'archived' - columns sales-order,
12 matches
Mail list logo