Jens, That is great news! You've made my day -- that means that the rest of my tables should work with JOIN queries, as I am building them along the same model -- using ID numbers instead of actual names to connect to the main "files" table. Thanks for clearing that up for me.
And also for the tip about using single ticks. Sincerely, Erik On Friday, November 30, 2001, at 01:53 PM, Jens Vonderheide wrote: > That's nearly correct. You could use > > SELECT files.file_name > FROM files, divisions > WHERE files.file_id = divisions.div_id > AND divisions.div_name = 'divisions1'; > > Note that both tables you wish to include in the query need to be > written > after the FROM command. This type of query is called a JOIN. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php