Yes that works great. Thanks Igor!
On 11 February 2013 22:24, Igor Tandetnik wrote:
> On 2/11/2013 10:45 AM, e-mail mgbg25171 wrote:
>
>> Perhaps I'm making a meal of my question...
>> "All" I want to do is
>> select only records that have field f1 = '' where it's other
On 2/11/2013 10:45 AM, e-mail mgbg25171 wrote:
Perhaps I'm making a meal of my question...
"All" I want to do is
select only records that have field f1 = '' where it's other field f2
matches the value of f3 only in other records (1 or more) which have a
non-'' f1 value.
select * from MyTable
I think this does it
sql_s = "select * from " & _
"(select * from tbl_tv a where new_tnode = '') " & _
"where pnode = 0 or pnode in " & _
"(select tnode from tbl_tv where new_tnode <> '' )" & _
"and anode = 0 or anode in " &
Perhaps I'm making a meal of my question...
"All" I want to do is
select only records that have field f1 = '' where it's other field f2
matches the value of f3 only in other records (1 or more) which have a
non-'' f1 value.
To explain the f1 field shows whether or not the record has been written
Here's a chopped down query that demonstrates my difficulty
do
sql_s = "select * from tbl_tv where id in " & _
"(" & _
"select id from tbl_tv where " & _
"new_tnode = '' and " & _
"pnode = 0 or " & _
5 matches
Mail list logo