Regarding Join

[adeeb]

Hi,
I actually have three rows in addissue table but when i run this query i am getting nine. Here expiry is a view.

   
select a.added,a.curr_date,e.days from addissue a,expiry e;

So please any body correct me.
Thanks and regards.

[danielstoner]

You create a cartesian product with this query. So you get all the possible combinations of rows from the two source tables. To get only what you want you have to create a join. The simplest way is to add a where clause and to specify what column in "expiry" refers to what column in "addissue":

where e.issue_id = a.id