hi team,
need your suggestion in following scenario.
i have two tables as below with data
select id , name , loacation, preference from tbl_maindata
id name location preference
a0001 GSc1 del a1
a0002 gsc2 del a1
a0003 gsc3 del a1
b0001 GSc1 mum bl
ab002 gsc2 mum bl
b0003 gsc3 mum bl
select * from id, name , loacation, preference from tbl_seprator where name = 'sep'
id name location preference
s00009 sep sep sep
i need data from tbl_maindata and when a particular lacation and preference is ended then a record from tbl_seprator on the base of above query
should be appear there.
id name location preference
a0001 GSc1 del a1
a0002 gsc2 del a1
a0003 gsc3 del a1
s00009 sep sep sep
b0001 GSc1 mum bl
ab002 gsc2 mum bl
b0003 gsc3 mum bl
s00009 sep sep sep