Insert Select query problem

Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative values; request, which

Re: Insert Select query problem

Ed Reed wrote: Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative

Re: Insert Select query problem

Thanks Jay, I had to make a change to the first part of the query to get the results that I wanted but your suggestion was definitely what I needed to get to the solution. Thanks again. For those that are interested, here's the final solution, INSERT INTO purchase (Source, Item, Qty)

Re: Select query problem

Barry wrote: Nenad Bosanac schrieb: Hi I have one problem that i can`t resolve. still need advice or is it solved? IF!!! you need IF!! :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select query problem

Nenad Bosanac schrieb: Hi I have one problem that i can`t resolve. still need advice or is it solved? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Select query problem

Hi I have one problem that i can`t resolve. I have 3 tables TABLE `predmet` ( `PredmetID` int(10) unsigned NOT NULL auto_increment, `BrojPredmeta` int(10) unsigned NOT NULL default '0', `VrstaPredmetaID` int(10) unsigned NOT NULL default '0', `KorisnikID` int(10) unsigned NOT NULL

Re: Insert select query problem

Luis Lebron [EMAIL PROTECTED] wrote: I am try to copy a couple of fields from one table to another. Here is my query Insert into users_test (firstName, lastName) Select firstName, lastName from users; The users table has 1,263 rows. However, only 1 row is inserted into users_test.

Insert select query problem

I am try to copy a couple of fields from one table to another. Here is my query Insert into users_test (firstName, lastName) Select firstName, lastName from users; The users table has 1,263 rows. However, only 1 row is inserted into users_test. If I perform the following query Insert into

FULLTEXT indexes and select query problem

I found some stuff in the mySql manual about setting columns as fulltext indexes for fulltext searches and the syntax is WHERE MATCH (column names...) AGAINST (the search stuff) So I went in and did an alter table statement to set my four search columns to be in a fulltext index. So here's the

Re: FULLTEXT indexes and select query problem

At 21:56 -0500 3/3/03, Stitchin' wrote: I found some stuff in the mySql manual about setting columns as fulltext indexes for fulltext searches and the syntax is WHERE MATCH (column names...) AGAINST (the search stuff) So I went in and did an alter table statement to set my four search columns to

re: Escaping characters in select query problem...

Mike, Monday, September 09, 2002, 2:45:36 AM, you wrote: M  I am having trouble with an sql query. I have a table with a column that M  has an '#' sign in the name. The problem is I can't seem to escape the M  column name to be able to select it. M  IE: M  select test#1 from test or select

Escaping characters in select query problem...

I am having trouble with an sql query. I have a table with a column that has an '#' sign in the name. The problem is I can't seem to escape the column name to be able to select it. IE: select test#1 from test or select `test#1` from test Both don't work and i get the error Unknown column

SELECT QUERY Problem

Hello, I often run into the problem of trying to join several tables and select just the most recent (or largest) item from a series of entries. For example. Table 1: names Id | name 15 | George 16 | Suzy Table 2 : scores_1 Id | score 15 | 85 15 | 60 15 | 70 15 | 95 Table 3 : scores_2 Id

AW: SELECT QUERY Problem

Hi. Try this one: SELECT MAX(score) FROM scores_1, scores_2 WHERE Id = 15 Greetz - Daniel Backhausen -Ursprungliche Nachricht- Von: Anatole [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 11:32 An: [EMAIL PROTECTED] Betreff: SELECT QUERY Problem Hello, I often run

Re: SELECT QUERY Problem

Hi, Table 1: names Id | name 15 | George 16 | Suzy Table 2 : scores_1 Id | score 15 | 85 15 | 60 15 | 70 15 | 95 Table 3 : scores_2 Id | score 15 | 50 15 | 55 15 | 60 15 | 45 What I want to end up with is a selection that would pick up George and his highest score on score_1

MySQL Multi-Table Select Query Problem

Hey folks, I'm new to the list and already have a problem. if you go to http://www.acnsnet.com/czc/show.php?state=Bayern You can see my problem with this query. This thing is killin me so if you have any ideas just shout. thanks, chuck Chuck's Top 10 Things to Remember and Think about!