Jump to content


Photo

Duvida de Select

Mysql select tabela

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

#1 shogun89

shogun89

    Normal

  • Usuários
  • 91 posts
  • Sexo:Masculino
  • Localidade:marilia

Posted 24/12/2015, 03:10

Boa tarde,
estou precisando fazer um select de 2 tabelas.

Na tabela grupo, quero que pega-se tudo que fica-se entre esses 2 campos  cat_inicio a cat_final

 

Ex. Tabela do grupo

cat_inicio = "A00" ao cat_final = "A09"

cat_inicio = "A10" ao cat_final = "A14"

cat_inicio = "A15" ao cat_final = "A19"

 

Tabela categoria

cid_categoria(id,descricao)

'A00','nome 1'
'A01','nome 2'
'A02','nome 3'
'A03','nome 4'
'A04','nome 5'
'A05','nome 6'
'A06','nome 7'
'A07','nome 8'
'A08','nome 9'
'A09','nome 10'
'A15','nome 11'
'A16','nome 12'
'A17','nome 13'
'A18','nome 14'



#2 Danilomaru

Danilomaru

    Ativo

  • Moderadores
  • 300 posts
  • Sexo:Masculino
  • Localidade:brasil

Posted 11/01/2016, 05:59

Acredito que o between funcione nesse caso.

 

Select * from tabela where campo between 'A00' and 'A09'



#3 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 20/09/2017, 17:32

Order Synthroid Online No Prescription generic cialis Viagra Generika Bewertung Canadian Pharmacy Flagyl Online Drugstore Zithromax Single Dose Chlamydia cialis Is Amoxicillin A Blood Thinner
Real Stendra 50mg Medicine Amex Fedex Shipping Next Day cialis Cephalexin 500mg Doasage Cialis 5mg Online Bestellen Generic Provera Propecia Dermatology Le Propecia Et Il En Vente Libre cialis online Cialis Fur Diabetiker

#4 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 06/10/2017, 17:43

Get Fluoxetine cheap cialis What Does Kamagra Do
Paying Too Much For Viagra The Antibiotic Cephalexin viagra Cialis Prix 10mg

#5 HaroNism

HaroNism

    Super Veterano

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

Posted 07/10/2017, 12:55

Levitra 10 Mg Quotazione Propecia Covered By Health Insurance viagra Cialis Generic Vs Brand
Propecia Daily Dose Pilules Cialis En Generique Ou Les Commander Viagra Pour Hypertension viagra online prescription Viagra Les Effets Levitra Efectos Adversos Propecia Instalar

#6 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 13/10/2017, 08:37

Propecia Cheapest Propecia Farmacia Kamagra Vendita buy cialis Cheap Erectile Dysfunction Drugs Veterinary Dosage Of Cephalexin
Pharmacy Online 365 Reviews Purchasing Acticin Drugs Antibiotic With Out An Rx cialis Canadian Prescription Pharmacy Coutu Priligy Venta En Espana

#7 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 25/10/2017, 10:41

Clomid Acheter viagra Drug Interaction Dogs Cephalexin Buy Flagyl Online No Prescription
Alli Avaibility Cephalexin Monohydrate Shelf Life Meglio Viagra O Levitra cialis Prednisone No Script Canadian Cialis 20mg Testberichte Discount Isotretinoin Buy
Finasteride Nausea Propecia Mechanism Generic Propecia cialis Ist Levitra Rezeptpflichtig Bestellen
Buy Prevacid 24 Hr Buygenericlevitraonlineusa Isoretinoin Without Prescription levitra 20mg prix Uschemist On Line
Kamagra Drop Shipping Dosage For Amoxicillin 500 Mg Amoxicillin For Oral Suspension Expire viagra What Is Amoxicillin Used On
Viagra 3 Day Delivery Allopurinal And Keflex viagra Urologo Priligy What Does Cialis Taste Like Dapoxetine A Vendre

#8 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 17/11/2017, 09:53

Viagra Frau Bericht Worldwide Direct Acticin 30gm viagra online pharmacy Amoxicillin Cough Seraph And Buy Orlistat 60 Mg With No Prescription

#9 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 26/11/2017, 06:19

Propecia To Regrow Eyebrows cialis buy online Viagra E Ipertensione Polmonare
Where Can I Buy Nolvadex Pct Surdosage Levitra Cialis 5 Compresse viagra Buy Generic Propecia 5mg Online Synthroid No Prescription
Levitra Valore Comprar Cialis Recomendado Feldene Canadian cheap cialis Priligy Stories
Viagra Sin Prescripcion Por Venta viagra Cialis 20mg Preis Osterreich Isotretinoin Free Shipping





Veja alguns posts relacionados com: Mysql, select, tabela

0 user(s) are reading this topic

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

IPB Skin By Virteq