PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 25
→
Aula 1116 WebDev22 curso 016 Criando Select Cliente e Representante
Aula 1116 WebDev22 curso 016 Criando Select Cliente e Representante
Started by amarildo, Apr., 11 2017 9:44 AM - No answer
Connect yourself…
amarildo
#1
Registered member
535 messages
Popularité : +14 (14 votes)
Posted on April, 11 2017 - 9:44 AM
Na dica de hoje,
vou criar duas sql,
cliente e representante
En el consejo de hoy,
Voy a crear dos sql,
cliente y representativa
En el consejo de hoy,
Voy a crear dos sql,
cliente y representativa
// QRY_CLIENTE
SELECT
cliente.id_empresa_cliente AS
C
LI_ID_EMPRESA_CLIENTE
,
cliente.id_cliente AS
C
LI_ID_CLIENTE
,
cliente.razao_social_nome AS
C
LI_RAZAO_SOCIAL
FROM
cliente
ORDER
by
cliente.razao_social_nome
// ESTOU SELECIONANDO CLIENTES, TRAZENDO CODIGO,NOME E ORDEM nome
// I'M SELECTING CUSTOMERS, BRINGING CODE, NAME AND ORDER name
// SELECCIÓN DE CLIENTES traigo CODIGO, NOMBRE Y ORDEN nombre
//QRY_REPRESENTANTE
SELECT
representante.id_empresa_representante AS REP_ID_EMPRESA_REPRESENTANTE
,
representante.nome AS REP_NOME
FROM
representante
// ESTOU SELECIONANDO DA TABELA REPRESENTANTE, CODIGO E NOME
// I AM SELECTING FROM THE TABLE REPRESENTATIVE, CODE AND NAME
// Estoy seleccionando TABLA DEL REPRESENTANTE, CÓDIGO Y NOMBRE
http://windevdesenvolvimento.blogspot.com.br/2017/04/aula1116webdev22curso016criando-select.html
Report
0
0
→ Go back to WINDEV 25
WINDEV 25
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text