SQL INNER JOIN WHERE

[Johnny42]

strSQL3 = "INSERT INTO tblInventaireManip (refInventaire,Qty,Remarque)"
strSQL3 = strSQL3 & " SELECT refMaterial,0,'Initial quantity' "
strSQL3 = strSQL3 & "FROM tblMaterial"
strSQL3 = strSQL3 & "WHERE [tblMaterial].Rouleau = 0"

why is the where not working ?

 

[PHV]

I don't see any INNER JOIN.
Seems like a lack of space before the WHERE clause.
Does the field Rouleau allow null ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny42]

Thnaks, GOT IT !