Syntax for Multiple Where Clauses

[#1]

I want to use two where clauses for the same table:

from...

Where Year("Oppo_Opened")>=2010

Where Field("Oppo_Type") = Record(Sales);

What is the correct syntax for this?

[MarcoWedel · Accepted solution]

Where Year("Oppo_Opened")>=2010 AND Field("Oppo_Type") = Record(Sales);

[MK_QSL]

Use only one Where and And between two conditions...

Something like

Where Customer = 'A' And Country = 'B'

[MarcoWedel]

Are you talking about SQL selects, because your where clause does not seem to be QV script load syntax?

[#5]

Thanks guys!

Definitely on the right track, but my syntax is still off. 

For the second one -- how do i do  -- WHERE (Fieldname) contains RecordName.

I have several opportunity types, but I only want to load those that have 'Sales' in Oppo_Type field.

[MarcoWedel]

Where Oppo_Type = 'Sales';