Posts by Guilherme Marques • 54 points

• 2

  votes

  2

  answers

  256

  views

  A: Concatenate columns and return the relation by SELECT

  Well, I found the explanation a little confusing. But in theory if you do Join between the 4 tables, you can put any information in your select. The code below meets you? SELECT A.Col 2, A.Col 3,…

  mysql sql sql-server

  answered 5 years, 4 months ago Guilherme Marques 54

• 1

  votes

  1

  answer

  30

  views

  A: How to Properly Organize Tables in a System

  As I would create; 1 - Proof (Codprova, Data, Materia, Pontos) 2 - Proof (Codquestao, Codprova, Text) 3 - Provaquestaoalternativa (Codalternativa,Codquestao,Text,Alternativacorreta(Yes or No))…

  mysql sql postgresql

  answered 5 years, 4 months ago Guilherme Marques 54