0

Hi i just have problem in my software
i just want to apply more then one condition in my quary which is joined "and" operator
plese helpe me by given an example(coding)
it is very urgent

3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by vb5prgrmr
0

Well I hope you catch your quary but as far as queries go, see this example...

strSQL = "SELECT * FROM table WHERE field1 = '" & somestringvalue & "' AND field2 = " & somenumericvalue

Good Luck

1

i think he is doing this

select table1.ID, table2.ID as ID2 FROM table1 INNER JOIN table2 ON table2.table1_ID = table1.ID WHERE table1.active = -1 and table2.active = -1
Votes + Comments
hi have no two tble ,
0

hi have no two tble ,
i joining on more then one field in a table
my table have, the follwing fields
transport,gr.no.,date,item,billno,frame size,sale billno,status,curr status,
here i can search for a item where salbill is "" , and also want to code for
searching all null value in a particullar field
please help me

0

Well if it is a text field then...

strSQL = "SELECT * FROM tablename WHERE fieldname = ''"

Good Luck

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.