I have two tables in SQL and I need to perform a search. The tables and fields are:
Employees: 'code' and 'EmployeeName'
Team: 'CodeEquipe' and 'RegisteredEngine', where 'RegisteredEngine' is linked to the 'Code' of the Employees table;
Th...
I have a query that returns the number of phones registered in each state, country and also brings the number of clients that do not have a telephone number registered in each state, but parents would like to bring only those clients that do not...
I need to do an integration between two sws in the house and I need help.
I have an integration table (3rd) that will receive the data of a new management, if it is created or modified.
For this, I have a view that brings the source data a...
I am performing the following capture of a date:
$dtInicial = $this->_getParam('dataInicial'); // Padrão dd/mm/aaaa
To search the precise database, leave it in the yyyy / mm / dd pattern:
$dt1 = date('Y-m-d', strtotime($dtInicial));...
I have a table of cities where I have zip codes.
The data looks like this: 89620000
I would like to leave them like this: 89620-000
How can I do this in Firebird?
I'm doing a query query, based on a table.
In this table (tableA) I bring several records from other tables, with some codes but one in particular is giving me a certain headache.
There is a record in tableA that can be NULL and in this ca...
Good afternoon, I have a table called Pessoa and another Matricula , I need to make a query that returns the fields name , enrollment and seq_people , where name and seq_people are in the Pessoa table and matricula in...
I have a table for image registration that is used as foreign key for other tables. The problem is that in one of these tables (PROMOCOES) the ratio is 1: N (a promotion for N images), while in the other tables the ratio is 1: 1.
My question is...
What are the main differences in change and modify, in which cases should I use them?
alter table cadastro change nome nome varchar(20);
alter table cadastro modify nome varchar(30);
I have a code problem that I can not understand. The postgres always points to the error _ "column reference" pro_codigo "is ambiguous" _, however I gave the "nicknames" the column pro_codigo . I can not see the meaning.
SELECT DISTINC...