You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community, you will:
have access to post topics
communicate privately with other members (PM)
not see advertisements between posts
have the possibility to earn one of our surprises if you are an active member
access many other special features that will be introduced later.
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":
Code:
where e.issue_id = a.id
__________________
Daniel @ [ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. ]
Language is froth on the surface of thought
Linear Mode
