Questions tagged as 'inner'

Good night guys, I need to link two tables and I can not fix it or find where I'm going wrong. I have two tables: Table 1: br_regiao | id - iduf - name - (1, 1, Litoral) Table 2: br_stat | id - name - (1 - Santa Catarina) Query: nam...

How do I make a select that assigns the value "10" in all of the games column? NOTE: Do not give update in the table. /*minha_tabela*/ codigo jogos --------------------- 1 10 2 10 3 10...

I am using INNER JOIN in mysql to merge and display the data. Tables and data insertion: CREATE TABLE EXPERIENCIA( exp_pri INT NOT NULL AUTO_INCREMENT, experiencia VARCHAR(100), PRIMARY KEY(exp_pri) ); CREATE...