Jump to content


Photo

Mysql: Select Dentro De Select


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

#1 BrunoCunha

BrunoCunha

    Turista

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

Posted 03/11/2004, 09:21

Tenho o seguinte problema:
Tabelas:
- tb_professor
- tb_disciplina
- tb_professor_disciplina

Eu quero pegar todas as disciplinas da tabela tb_disciplina que ainda não tenham sido associadas a um certo professor, ou seja, eu passo o ID do professor e ele me retorna todas as disciplinas que ele não está associado.

A idéia seria essa, mas dá erro de Syntax!

SELECT d.in_sq_disciplina, d.vc_nm_disciplina
FROM tb_disciplina d
WHERE d.in_sq_disciplina NOT IN (SELECT in_sq_disciplina FROM tb_professor_disciplina where in_sq_professor= 79)

O erro é esse:
[eprovas] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT in_sq_disciplina FROM tb_professor_disciplina where in_s

Alguma idéia???

Vlw

#2 Prog

Prog

    ...

  • Ex-Admins
  • 3761 posts
  • Sexo:Masculino
  • Localidade:Rio de Janeiro/RJ
  • Interesses:TI, Software Livre, Design Digital e Rock'n'Roll.

Posted 03/11/2004, 09:51

Esta funcionalidade apenas esta disponivel apartir da versão 4.1 do MySQL.
------
Mero mortal!

#3 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 17/09/2017, 04:50

Amoxicillin 500mg Times A Day cheap cialis Cialis Prix Pharmacie Maroc
Priligy Generico Espana Cialis Caracteristicas Ondansetron
Le Cialis 10 <a href=http://cialtobuy.com>online pharmacy</a> Gnc Natural Viagra
Viagra Kaufen Augsburg generic cialis Groovorio
Cialis Comprare In Farmacia Mauritius Pharmacy Online
Overnight Prescription Antibiotics <a href=http://cialtobuy.com>cialis</a> Prezzo Kamagra Turchia
Cytotec A Bas Prix cialis Cialis Tabletas 10 Mg
Viagra Rezeptfrei Online Kaufen Acheter Cialis En Suisse Effetti Collaterali Levitra
Cialis Tadalafil Internet <a href=http://cialtobuy.com>online pharmacy</a> Clomid Fast Delivery

#4 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 04/10/2017, 04:43

Sure Romance Viagra Dove Acquistare Amoxicillin To Treat Acne levitra vs viagra vs cialis Levitra Cialis Generico
We set ourselves apart from other hard money lenders by doing the following Fix Flip Loans Los Angeles California Fix Flip Loans Orange County CA Shortterm fix flip loans rehab loans construction loans bridge loans nonowner occupied only Loan amounts ranging from to Copyright Short term to months The term hard money lender refers to a class of private lender that underwrites primarily to a loans collateral value the borrowers hard asset rather than to the borrowers credit. cash advance loans Nice Quick cash is something everyone wants Im sure and here are brilliant ways to achieve this.

#5 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 11/10/2017, 14:16

Online Stendra Discount viagra Acheter Vrai Propecia
Viagra E Glande Oxetine generic viagra Viagra Cialis Levitra Sample Pack Purchasing Viagra Online For Cheap
Amoxicillin 50mg buy viagra Priligy Temoignages Online Levitra Viagra Kamagra With Paypal Uk

#6 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 28/10/2017, 18:55

Cheap Fluoxetine Antidepressant Prague online pharmacy Viagra Cialis Combo Pack Achat Cytotec Algerie Amoxicillin Boils
Glucosamine With Amoxicillin Where Can Propronolol Be Purchased online pharmacy Avana Costo Del Viagra En Mexico Viagra Donde Comprar Precio
Zithromax Three Days viagra prescription Kamagra Historia Recomended Amoxicillin Doses For Sinus Infections Nizagara Tablets

#7 LarPhozyHah

LarPhozyHah

    Super Veterano

  • Usuários
  • 14515 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 28/10/2017, 21:53

Free Shipping Pyridium C.O.D. Low Price Amoxicillin And Canine Whelping cialis buy online Commander Viagra Ligne Cialis Viagra Differenze

#8 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 16/11/2017, 15:42

All Needed Pills Viagra O Cialis Senza Ricetta Medica cialis Viagra Original Tabletten Necesito Tomar Cialis Schlecker Levitra
Tadalis Sx Soft Chef Projet Moa Amoxicillin Doasge For Children cialis online Difference Between Amoxicillin And Augmentin
Cialis Granada Viagra Dose 200 Mg levitra billig Propecia Efectivo Pelo




0 user(s) are reading this topic

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

IPB Skin By Virteq