SQL Query

[suprsnipes]

Hi,

 

I'm trying to perform the following SQL which is based on the following query that works fine;

 

SELECT * FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1`

 

What I am trying to do which I am stuck on is I want to label the result as an 's' and insert the result into another table where the column 'id' is the same, in saying that how do I allow for the 'id' column?

 

Basically I want to

INSERT INTO `day` (`class`)  VALUE ('s') in conjunction with the above SQL query...

 

But perhaps I need to include the id so they match, for example id=id

[suprsnipes]

This is what I have tried so far but just can't seem to get it right.

 

SELECT `id` FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1` SELECT `day` `class` INSERT INTO `day` `class` VALUES 's'

 

[Ken2k7]

What!? Sorry, I don't follow a thing you said.

[gassaz]

Reading a bit i found an example similar to your request..

 

INSERT INTO `day` (`id`, `class`)  VALUE (SELECT `id`, `class`='S'  FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1`)

[fenway]

Reading a bit i found an example similar to your request..

 

INSERT INTO `day` (`id`, `class`)  VALUE (SELECT `id`, `class`='S'  FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1`)

That's not valid... you mean

 

INSERT INTO `day` (`id`, `class`)  VALUE (SELECT `id`, 'S'  FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1`)