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.

Reply via email to