Comparing three column records in a mysql table

Asked

Viewed 58 times

0

I make an appointment at COL1 which has the total of lines and then make an appointment at COL2, but it is smaller than COL1. How do I make COL2 return me the Ids equal to those of COL1 so that they are side by side according to the COL1 ID to see who is equal and who is different. I have to fill with zeroes to COL2 pushing the Ids down to match the Ids? inserir a descrição da imagem aqui

  • are in the same table or 3 different tables?

  • It’s the same table friend. I have to compare the values of the three columns, so I have to join the three side by side, that is, add a 0 or something in the records that do not have in the other two columns so that they can have the same number of rows.

  • Please put what you already have in the moment.

  • Hello Rogério, the table is too big to put here. I put a small part of it.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.