Consulta todos imóveis pertencentes a um locador

From Grupo05 Ahand

Revision as of 01:11, 12 December 2006 (edit) Cmgoto78 (Talk | contribs) ← Previous diff		Current revision as of 00:39, 13 December 2006 (edit) (undo) Cmgoto78 (Talk | contribs)
Line 8:		Line 8:
	[[Image:ConsultaImoveisCPF CRT.PNG]]		[[Image:ConsultaImoveisCPF CRT.PNG]]
		+
		+	== SQL ==
		+
		+	SELECT imoveis.rua, imoveis.numero, imoveis.bairro, imoveis.cidade
		+
		+	FROM  imoveis, rel_imovel
		+
		+	WHERE  rel_imovel.codigo = imoveis.codigo_imovel AND rel_imovel.cpf='12345678-09'

---

Current revision as of 00:39, 13 December 2006

Traz a Rua, número, complemento, o Bairro e a cidade de todos os imóveis pertencentes ao CPF=123456789-09.

[edit] Algebra relacional

[edit] Cálculo Relacional de Tuplas

[edit] SQL

SELECT imoveis.rua, imoveis.numero, imoveis.bairro, imoveis.cidade

FROM imoveis, rel_imovel

WHERE rel_imovel.codigo = imoveis.codigo_imovel AND rel_imovel.cpf='12345678-09'