> 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

Reply via email to