Posts by João Pereira • 29 points
6 posts
-
2
votes2
answers280
viewsQ: Select from 3 related SQL Server tables
Good, I have the following 3 tables: SELECT * FROM Cartao INNER JOIN Registo ON Registo.ID_Cartao=Cartao.ID_Cartao INNER JOIN Clientes ON Registo.ID_Cliente=Clientes.ID_Cliente WHERE…
-
0
votes2
answers43
viewsA: Query to know which books students do not have, in SQL
SELECT * FROM Livro INNER JOIN RegistoLivroAluno ON RegistoLivroAluno.ID_Livro = Livro.ID_Livro INNER JOIN Aluno ON RegistoLivroAluno.ID_Aluno = Aluno.ID_Aluno WHERE Aluno.ID_Aluno =…
-
-6
votes2
answers43
viewsQ: Query to know which books students do not have, in SQL
Good, I have the following tables Livro: ID_Livro PK Nome Aluno: ID_Aluno PK Nome RegistoLivroAluno: ID_Registo PK ID_Aluno (chave extrangeira de Aluno) ID_Livro (chave extrangeira de Livro) ) I…
-
0
votes3
answers89
viewsA: How to make the first letters that the user type uppercase?
Some of this string name; do{ cout << "Qual o nome?"; getline (cin,name); }while (nome[0]>='A' && nome[0]<='Z');
c++answered João Pereira 29 -
0
votes1
answer131
viewsQ: C Language - Read File to Save to Lists
Imagine a school with several classrooms, and each room has several students I’m having trouble reading file with the name of the room, number of places by rows (rows and columns) I have the…
casked João Pereira 29 -
1
votes3
answers89
viewsA: How to make the first letters that the user type uppercase?
Thus, you are forcing the user to put the first uppercase letter char nome[50]; do{ printf("Qual o nome?\n"); scanf("%c", nome); }while (nome[0]>='a' && nome[0]<='z');…
c++answered João Pereira 29