Guest shivani Posted May 3, 2006 Share Posted May 3, 2006 hialli want a help for query which i need 2 search a recordi a using access db. the 2 tables contains following fields1. sno ven_dor nature emp_no2 sno1 problem desc ven_dor1 emp_no1now wat i want to search for employee no. the both tabels can have same employee no. i m using query like thisSELECT * FROM data, data1 WHERE (sno=sno1 ven_dor=ven_dor1) AND emp_no OR emp_no1 like ?";i m getting all other record other than wat i have entered.can anybody plz help me outregardsshivani Link to comment Share on other sites More sharing options...
Nakor Posted May 3, 2006 Share Posted May 3, 2006 What you do you mean you are getting all records other than what you have entered? If you are trying to search 2 database tables as one they should have the same structure, which they appear to, and then you should utelize the MySQL merge type so that you can then just create one simply query. Link to comment Share on other sites More sharing options...
justsomeguy Posted May 3, 2006 Share Posted May 3, 2006 SELECT * FROM data, data1 WHERE (sno=sno1 AND ven_dor=ven_dor1) AND (emp_no like ? OR emp_no1 like ?)"; Link to comment Share on other sites More sharing options...
Matar Posted May 6, 2006 Share Posted May 6, 2006 hi try this code and it get all recored <%Dim conn Dim rs Set Conn = Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.Mappath("/webdata/tst.mdb"))set rs = Server.CreateObject("ADODB.recordset") sql= "SELECT name FROM data, data1 WHERE 'sno = sno1 ' AND 'ven_dor = ven_dor1' AND 'name like ? '"set RS = Conn.Execute(SQL)do until rs.EOF for each x in rs.Fields Response.Write(x.value ) Response.Write(x.name & "<br />") next rs.MoveNextlooprs.closeconn.close%>this is the result samerenamesamerenamemohdnamemohdnamei have just 2 field and it is get the both field Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now