1 2 3 4 5 6 7 8 9 10 11 12
|
celle ci fonctionne :
sql = "SELECT sculfort_stock.*, sculfort_article.*, sculfort_affaire.*, sculfort_plateau.*, sculfort_kardex.* FROM sculfort_stock LEFT JOIN sculfort_article ON sculfort_stock.id_article = sculfort_article.id_article LEFT JOIN sculfort_affaire ON sculfort_stock.id_affaire = sculfort_affaire.id_affaire LEFT JOIN sculfort_plateau ON sculfort_stock.id_plateau = sculfort_plateau.id_plateau LEFT JOIN sculfort_kardex ON sculfort_plateau.id_kardex = sculfort_kardex.id_kardex WHERE sculfort_stock.id_article =" & Rst4("id_article")
sql = "SELECT sculfort_stock.*, sculfort_article.*, sculfort_affaire.*, sculfort_plateau.*, sculfort_kardex.* FROM sculfort_stock LEFT JOIN sculfort_article ON sculfort_stock.id_article = sculfort_article.id_article LEFT JOIN sculfort_affaire ON sculfort_stock.id_affaire = sculfort_affaire.id_affaire LEFT JOIN sculfort_plateau ON sculfort_stock.id_plateau = sculfort_plateau.id_plateau LEFT JOIN sculfort_kardex ON sculfort_plateau.id_kardex = sculfort_kardex.id_kardex WHERE sculfort_stock.id_article =" & Rst4("id_article") & " GROUP BY sculfort_stock.id_plateau"
mm si je fais ca :
sql="SELECT * FROM sculfort_stock GROUP BY id_plateau" |
Partager