arcpy.Select_analysis - Multiple conditions for where_clause

RayHardjadinata1

Hello,

What is the proper syntax for where_clause when I have multiple conditions?

This is what I got when I exported from my model builder:

arcpy.Select_analysis(in_features = Pipe_Table__WGS_PIPE_,
                                    out_feature_class = WGS_PIPE,
                                    where_clause = "PIPE_DIAMETER <= 20 And SYS_ZONE <> 0 And OWNER = 'WDD' And USE_TYPE IN ('DIST', 'TRUNK', 'LSLATERAL', 'MANIFOLD') "

                                     )

The above returns me an error.

However, if I just do one condition such as the following below, it works... 

arcpy.Select_analysis(in_features = Pipe_Table__WGS_PIPE_, 
                                    out_feature_class = WGS_PIPE, 
                                    where_clause = "PIPE_DIAMETER <= 20" )

Can anyone please help? Thanks! 

DanPatterson_Retired

I guess 'And' is somehow correct , but I got failures without specifying a workspace first OR the full path to the source and destinations

arcpy<SPAN class="punctuation token">.</SPAN>analysis<SPAN class="punctuation token">.</SPAN>Select<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Git_Dan\npgeom\npgeom.gdb\Polygons"</SPAN><SPAN class="punctuation token">,</SPAN>
                      r<SPAN class="string token">"C:\Git_Dan\npgeom\npGeo_1.gdb\x1"</SPAN><SPAN class="punctuation token">,</SPAN>
                      <SPAN class="string token">"A0 = 'A' And A1 = 'a'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>