> So far I have successful set up tables in mysql > InnoDB > with primary and foriegn keys. Unfortunately I am > having some difficulty in getting the proper results > as I am new to sql and databases. I would be most > grateful if someone took a minute and explained or > helped with the following : > > Assume three tables were created in mysql innodb > with > the following: > Table A:one to many:type will have many reg(Table C) > > type primary key not null, > type_id auto_increment not null > > Table B:one to many:pn & datep will have many > reg(Table C) > pn primary key, > datep ** note for every pn their > is a corresponding datep ** > pn_id auto increment > > Table C: > cite , > reg blob not null primary key, > type_id refernces Table A foreign key, > pn_id references Table B (pn) foriegn > key, > pn_id references Table B(datep) forieng > key, > > ** Note that the syntax is not proper, but this is a > theory type question ** > > My problem is how to get a query result with > the following columns from above tables : > > type (table A) cite (Table C) reg > (Table > C) pn (Table B) datep (Table B) > > > Do you only query Table C or do you structure the > query to get info from all three tables? > > Thankyou for your time and consideration of > this problem senario ! >
===== Regards, Investorclb __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ --------------------------------------------------------------------- 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