View Full Version : Join 2 Stores

17 Dec 2010, 12:54 AM

i want to join two stores with names publishers and zones

publisher = store_publishers.getById(rownum); //get publisher from store with its id = rownum
publishername = publisher.get('publishername');

//retrieve all zones where publishername is equal

queryset = store_zones.query('publishername', publishername);

my queryset gets 0 records but i have 15 records in store zones.

store_publishers has an field publishername and also store_zonez has it. so i must get the join like this.

what do i wrong ?

im open for all advices, thnx