thats my Querry:
sql="SELECT * FROM tblfonds AS A, tblfondsperformance AS B WHERE A.wpk=B.wpk AND A.wertpapiername LIKE '%$such%' OR A.wpk LIKE '%$such%' ORDER BY wertpapiername";
i search in 2 tables, first in the field "Wertpapiername" , then in the field "WPK" If the querry has an answer in the first field, its all ok. if not, the querry give me all my datasets return ( more than 4.000). When i have only one table, no problem. I think my INNER Join is wrong. I need help. thanks, Guido
sql="SELECT * FROM tblfonds AS A, tblfondsperformance AS B WHERE A.wpk=B.wpk AND A.wertpapiername LIKE '%$such%' OR A.wpk LIKE '%$such%' ORDER BY wertpapiername";
i search in 2 tables, first in the field "Wertpapiername" , then in the field "WPK" If the querry has an answer in the first field, its all ok. if not, the querry give me all my datasets return ( more than 4.000). When i have only one table, no problem. I think my INNER Join is wrong. I need help. thanks, Guido