[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] i need solution to this problem
From:       Richard Broersma Jr <rabroersma () yahoo ! com>
Date:       2006-06-28 11:43:55
Message-ID: 20060628114355.48693.qmail () web31806 ! mail ! mud ! yahoo ! com
[Download RAW message or body]

> > I have tables like 1) emp_table (personal_no integer (foreign key),
> > cdacno varchar (primary key),name varchar);
> 
> > 2) Rank_table (rank_id varchar (primary key), rank_name varchar);
> 
> > 3) Rank_date_table (rank_id (foreign key), rank_date date);
> 
> > 4) Unit_table (unit_id varchar (primarykey), unit_name varchar);
> 
> > 5) Personal_table (per_no varchar (primary key), pername varchar);
> 
> > My query is ….if I give cdacno I have to get per_no from
> > personal_table.. With this I have to display rank_name from
> > rank_table ,name from emp_table, unit_name from unit_master..
> 
> it is not clear what the relationships are between the tables. for
> example what is the foreign key to unit_table?
> 
> how does the rank connect to emp_table or personal_table?

yes.  in addition to this,  it seems that 

emp_table references personal_table 
on personal_no = per_no.

But it is not clear how this is the case when personal_no is an integer and per_no is a varchar.

Regards,

Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
[prev in list] [next in list] [prev in thread] [next in thread]