Hi! Id would like to have 4 tables
files ( id int(8), type set("directory", "file", "link"), ) files_directory ( id int(8), is_files int(8), name varchar(20) ... ) files_file ( id int(8), is_files int(8), name varchar(20) ... ) files_link ( id int(8), is_files int(8), name varchar(20) ... ) And be able to make one query to get the info from, for example the "files_directory"-table just having an id for the "files"-table, such as: select files.type as #type, files_#type.* from files, files_#type where files.id =$id and files_$type.is_files=$id $id is a value from php-script #type is a for me imaginary value that I would like mysql to generate and being able to use. is this possible, or should I rename the values in the "files.type"-set to "files_directory, files_file, "files_link"? or wouldn't this help either? regards, tomas --------------------------------------------------------------------- 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