> > 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/ >
===== 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