Hi, I would like to understand how to generate dictionaries based on other dictionaries. For example, I have a 3 tables in ym SQL database - Groups, Categories and Sub-categories with a one-to-many relations between each.
I am presuming that each of these tables is one of my dictionaries?!?! What I don't understand is how to write this SQL statement in python code: SELECT id, category from Categories WHERE group_id = "1"; Can some one help me understand how to pass the group_id in a simple example, so that I can return all the categories from Category table. I am using the SQL example to figure it out in my head - perhaps this is a wrong way to look at this? Thanks David ______________________________________________________ New Online ID Theft Protection - http://www.tiscali.co.uk/spyguard _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
