Without joining tables how can u get desired results..
the ans wud be no to ur question..
Try with referencing code column of country as country_code in state table.
during loading from tempcode(source)..build a logic to load appropriate country code.
Abhay.
Last edited by abhaysk; 04-14-2003 at 03:30 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote