Mmm.. not good not good....

Bad luck

Thanks

Mmmm... that's sad

I guess I will use a temp table or something like that, thanks

Hi,

The thing is that the query I use has a GROUP BY clause because it has to get data from different referenced tables. In fact I'm grouping by months, but...

I haven't applied anything yet, but I understand what things I could do, I will experiment with both replies in my post, and also I was told that I could...

Thanks Everyone

Hi

SELECT proveedor.nombre, ((SUM(MaterialColocado.utilidadneta) / objetivo.utilidad)*100) AS enero

FROM usuario INNER JOIN

...

Hi,

It is ok, I was very confused a while ago, but now everything is workin, I just had to do better my query, but at the end it worked. I...

Thanks Everyone

Now it is working.

The thing is that I have no idea how to delete the constraint, because the code to drop foreign key does not work, I have to specify the foreign key...

Hi,

Well, it is kind of what you say,

I'm sorry I put category I meant "nombre" from table "proveedor".

So for instance,

When I insert a new "nombre" into proveedor

I want that...

Hello,

After talking with a professional programmer he told me that I was doing everything the wrong way,

What I want to do is best done with FOREIGN KEYS, I did not...

Thanks!

Ok,

Maybe I'm not understanding here is the thing:

my table1 already has this values

name | lastname

jim

jim

jim

my table2 already has these values

nickname | lastname2

anything johnson

other ...

Ok.. here is the thing

this is my situation

For instance,

One user registers, his name goes to one table several times like this

table 1

user | categories

name

name

name

name

name

name

then in another table i have the...

Hi,

I came to the conclusion that I could insert first the name values and then copy the values of one column to the other, the thing is that they are...