Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.26 » View Incident Report |
Serious |
Reported By: Rodrigo Pires Reported On: 1/30/2008 For: Version 4.26 Build 1 |
Simple ------ select imv.matricula, rua.desc, bai.desc from imovel imv inner join Rua rua on (rua.id = imv.rua) inner join Bairro bai on (bai.id = imv.bairro) Complex ------- select cap.capa, ime.capa, ime.imovel, imv.auto_inc, imv.cidade, cid.codigo from "capa_esc" cap inner join "esc_arq" esc on (esc.codigo = cap.esc_escreve) left join "cap2_esc" cap2 on (cap2.capa = cap.capa) left outer join "cusrj_es" crj on (crj.capa = cap.capa) left outer join "imv_esc" ime on (ime.capa = cap.capa) inner join "Imovel" imv on (imv.auto_inc = ime.imovel) inner join "Tipo_Rua" tru on (tru.codigo = imv.tipo_rua) inner join "Rua" rua on (rua.codigo = imv.rua) inner join "Bairro" bai on (bai.codigo = imv.bairro) inner join "Cidade" cid on (cid.codigo in (imv.cidade))
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |