Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
query where statement two row in same column
phv: yup, try already, but not quit work for the table i newly create the desease id = 4... -
query where statement two row in same column
the situation is like this, this is for desease detection, to make it simple, there are 2 table which are symptom and desease. The desease are determine by its symptom and 1 desease may have 1 or more symptom. the table above is for the desease table, sy_id is for symptom id(fk from symptom... -
query where statement two row in same column
thanks for reply guys, but the table dont actually like above,for some case, it can be like below ------------------------- id(pk) | sy_id | dm_id ------------------------- 1 | 1 | 1 2 | 2 | 1 3 | 1 | 2 4 | 4 | 3 5 | 1 | 4... -
query where statement two row in same column
below are my sample table ------------------------- id(pk) | sy_id | dm_id ------------------------- 1 | 1 | 1 2 | 2 | 1 3 | 1 | 2 4 | 4 | 3 -------------------------- as my first post "select * from table where sy_id = 1 and sy_id =... -
query where statement two row in same column
my query is "select dm_id from desease_details where sy_id = $val and sy_id = $val2" this query sure not working, anyone have idea how i can solve this? thnx
