i have two tables tableA tableB
in tableA i have
ID (int)
Name
active
in tableB i have (ID foriegn key)
ID (int)
Bid (int)
Addree
my question is i have to get all values from tableB
in which i have only value in hand is "active"
in tableA
active field values are 1
ID values are different say 1,2,3,4,5
in tableB
ID vales are 1,2,3,4,5
Bid values are 6,7,8,9
i have to get all values (Addree from tableB) using active
how can i pass these values to array to get the values of tableB