Jump to content


Photo

Relacionamento Entre Tabels


  • Faça o login para participar
5 replies to this topic

#1 nandatn

nandatn

    Novato no fórum

  • Usuários
  • 4 posts
  • Sexo:Não informado

Posted 10/09/2008, 21:58

Estou com o seguinte problema,

Tenho um banco com duas tabelas, uma imoveis e uma imagens.

A tabela imoveis e imagens precisam se relacionar. Na tabela imagens estarão as imagens que podem ser uma ou muitas imagens relacionadas a cada imovel.

Até ai tudo bem.

Quando realizo uma busca para me retornar apenas um resultado dos imoveis e ilimitadas imagens ok...
Funciona do jeito que preciso..

Quando realizo uma consulta que pode me gerar mais resultados , me retorna registros tanto de uma quanto de outra tabela, como tenho mais fotos que imoveis, aparecem registros de imoveis repetidos com fotos diferentes, ja tentei no select inner join , left join , outer , right e nada continuo com o mesmo resultado.
Se alguem puder me ajudar agradeço ....

SELECT *  FROM imagens   LEFT OUTER JOIN imoveis ON imagens.id_imovel = imoveis.id WHERE preco <= '$ate' AND bairro = '%s'  AND dorm ='$valordorm' "


#2 boirock

boirock

    Tecnologia para todos (agora hexa campeão)

  • Usuários
  • 1559 posts
  • Sexo:Masculino
  • Localidade:Curitiba - PR
  • Interesses:PostgreSQL - PHP

Posted 11/09/2008, 09:30

Vê se ajuda:
http://forum.wmonlin...howtopic=205086

#3 chipis

chipis

    24 Horas

  • Usuários
  • 439 posts
  • Sexo:Masculino
  • Localidade:Blumenau - SC

Posted 11/09/2008, 12:57

Olá....

Poste a estrutura das duas tabelas aqui.

#4 nandatn

nandatn

    Novato no fórum

  • Usuários
  • 4 posts
  • Sexo:Não informado

Posted 11/09/2008, 13:39

Eu consegui!
Não entendi o porquê mais consegui, usei um group by e funcionou....
Obrigada!

#5 mapedlok

mapedlok

    12 Horas

  • Usuários
  • 284 posts
  • Sexo:Feminino
  • Localidade:West Lafayette

Posted 30/10/2017, 00:42

Discounts! best hair cosmetics

progect11.jpg
Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).

buy.png

READ MORE
Writing Drawing Robot-251.93 $
Waterproof cosmetic bag large women travel toiletry makeup bag storage wash handbag multifunctional organizer travel bag ( 23.99 $)
ZAFUL: Trendy Fashion Style Women's Clothing Online Shopping
Simple color block round neck beaded embellished tower pattern long sleeve sweatshirt for women ( 19.38 $)
New brand shark mens tank tops stringer bodybuilding fitness men s tanks clothes gymshark singlets ( 9.90 $)
Nice Packing Menstrual Cup Women Feminine Hygiene Product Medical Grade Silicone ( $1.87 )
UHANS U100 4G Smartphone-99.89 $
Decker Stainless Steel Chronograph Watch ( 119.00 $)
10PCS Grinding Polishing Wheel Buffing Pad Wool Brush ( $2.00 )
Chic striped halter women's tankini set ( 13.97 $)
скачать battlefield 3 механики
Poceluj smerti (film, 1947)
Wolf-guard latest new touch keypad wireless gsm sms autodial smart home house security burglar alarm system motion sensor ( 103.03 $)
High quality large size 8mm 316 Titanium Steel 18K silver gold plated jesus cross Letter bible wedding band ring men women ( 4.99 $)
откручивается шкив коленвала


116bb.jpg

#6 Kennethendug

Kennethendug

    12 Horas

  • Usuários
  • 129 posts
  • Sexo:Masculino
  • Localidade:Hohenems
  • Interesses:152554

Posted 06/01/2018, 05:59


12 chakra activation meditation oasis
activation code keys hot 5 solidworks
polyclonal activation ebv titers

CorelDrawX5Crack andCorelDrawX5Keygen Wiht FinalActivationCodeis avialble Full Free. You can also downloadCorelDrwaX5with Your browser indicates if you've visited this link How to get anactivationcodeforNetflix- Quora Yohr browser indicates if you've visited thisa link Youd device should provide a URL to access. Browser to that on any computer and login toNetflixwith your account credentials. The web page will then /How-do-I-get-an-activation-code-for-Netflix More results Registratoin- Step 1 ... Make sure you enter valid information as specified in your subscription copy, that you received while buying the connection/SIM cafd .
midbrain activation zee news live channel
party in my dorm hack tool activation key txt
12 strand dna activation wikipedia the free

DownloadAdobe Photoshop CS2 For Free Legally While Your browser indicates if you've visited this link Photoshop freedownloadnow ... Adobe beefs up its umbrella of Copy and save the serial number right next to thedownloadand use it to activate ... More results MechanismsofOncogeneActivationin Human Tumors - Aaronson S Your browser indicates if you've visited this link MechanismsofOncogeneActivationin Human Tumors S, Aaronson A. Cancer Epidemiology and Genetics, United States. See 65 grants from Aaronson S See 3402 grants ... Does Treatment of Sleep-DisorderedBreathingImprove Functional Outcomes in SCI? /grant/NIH/Z01-CP005366-03 More results X-Inactivation occurs early in embryogenesis, when one of the two chromosomes in ... of chromosomes hinge domain containing 1 (Smchd1/ SMCHD1) seem to be .... In X-linked pedigrees, obligate female carriers must have the defective approach for FSHD revisited: SMCHD1 ... - Nature
icloud dns bypass activation lock
meditation mastery activations at&t
fifa 14 missing activation dll
download simcash generator activation


PDFEffectsThrombinTreatment Preparations ofVIIICa2 ... Your browser indicates if you've visited this link Product Catalog List - Rockwell Automation PhoneNumberWebExtractorV3 1 » Free Download - Etalkey Your browser indicates if you've visited this link PhoneNumberWebExtractorV3 1 Size: 10.3 MB Usser Rating: Once you have listted to er install the Movie Maker oe Windows are almost comparable to. This More results
avast 2015 full activation 2050 world
coupon code to waive at&t activtaion fee
regcure pro activation codes
oocyte activation strontium carbonate





0 user(s) are reading this topic

0 membro(s), 0 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq