Hi all
I have a database with two tables. The first one is a 'many' table, each
record represents one photograph. Among other keys is a foreign key for the
photographer. So, among the 250,000 records, a given photographer's ID will
show up hundreds of times. Also present is a foreign key that names the
category (marine, aviation, train, etc).
The second is a 'one' table. Each row here represents a person, with a
foreign key (to yet a 3rd table) that says he or she is a photgrapher.
How would I query my datasource and get a list photgraphers for just one
category like aviation?
Thanks!
* john *
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.