Win a copy of Transfer Learning for Natural Language Processing (MEAP) this week in the Artificial Intelligence and Machine Learning forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

advanced sql query

 
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Report post to moderator
I have the following relationship diagram
CLIENT(code,nom,prenom,localite,num_tel,categorie)
COMMANDE(num_cmd,#code,date_cmd)
ARTICLE(ref _article,designation,prix_HT, TVA)
LIGNE_CMD(#num_cmd,#ref_article,quantite,remise)
CHIFFRE_AFFAIRE(journee,montant)

write the SQL request that Display products that are ordered in all locations?
please someone can help me to write this request
 
Marshal
Posts: 68914
275
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please write any answers here.
 
This guy is skipping without a rope. At least, that's what this tiny ad said:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic