about searching
Posted: Thu Aug 19, 2004 4:43 am
i have a table which has two colums
now i want to select track_id where the search key is two st_ids.
like i want to find track id where st_id=34 and st_id=36
it should give me answer 1.
Code: Select all
track_id st_id
1 34
1 36
1 22
1 2
2 67
2 54
3 55
3 76
3 43
3 98like i want to find track id where st_id=34 and st_id=36
it should give me answer 1.