Data Controls :: Change StoreProcedure To Showing Data From 2 Table

I have 2 table in database

1-House_info

Id Name Behcode Subset H_name

1 Sara 1111 Electric House
2 Jack 2222 House
3 Micheal 3333 House

2-House_p

Id Model Behcode Subset H_name

1 Sofa 2222 Furniture House
2 Chair 2222 Furniture House
3 Curtain 3333 Curtain House

In House_info saved Users information and in House_p saved users Product Information

I have datalist in my page that bind from House_info table and if users insert their produt in House_p, their information from House_info will be bind ...

Below is SP

ALTER procedure [dbo].[GetCustomersPageWise2]
@H_name nvarchar(50)
,@subset nvarchar(30)
,@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT

[Code] ...

Here if users insert Their product into House_p table in datalist shows their information from House_info Table so here just shows users with behcode=2222,3333

In House_p table is Subset column if users select Item from menubar in Product.aspx page according to their selected Item it will show information in datalist

i.e

If they select Furniture from menubar it shows users information from House_info table that they inserted product with subset=furniture in house_p table

Now I want if users select item=Electric from menubar it shows users information from House_info table that subset=Electric   (but she didn't insert any Product in House_p table)

In above SP it just show users that insert Product in house_p table

I want shows both of them...