How to create the table for these expecting output?
Hi Friends,
i ve the table structure like
create table geoloc
(
pincode int primary key,
latitude float,
longitude float
)
insert into geoloc values('600004','13.0656','80.2672')
insert into geoloc values('600028','13.0206','80.2417')
create table cust_det
(
cust_id int,
pincode int foreign key references geoloc(pincode),
sales int
)
insert into cust_det values('101','600004','100')
insert into cust_det values('102','600004','150')
insert into cust_det values('103','600004','200')
insert into cust_det values('104','600028','300')
insert into cust_det values('105','600028','450')
in my application i m display the marker from database when i click the marker for particular marker now opens the info window in that i wanna show particular area sales
ex:
in 600004 marker i m choosen means the window ll show
cust sales
101 100
102 150
103 200
total 450
how to make code?