>
> SELECT
> O.opportunityId,
> O.title,
> N.ndaId,
> N.ndaDate,
> U.firstName,
> U.lastName,
> U.emailAddress
> FROM
> tbl_opportunity O
> INNER JOIN tbl_nda N ON (O.opportunityId = N.opportunityId)
> INNER JOIN tbl_user U ON (N.issuedById = U.userId)
>
> Here is the gist...
>
> Three table: opportunity, nda, user. User is a lookup table for
> users and opportunity and nda are linked together via opportunityId.
> Table nda can have more than one opportunity referenced in it. What
> I would like to do is to just get a listing of the opportunities for
> which there is at least 1 record in the nda table. Does that make
> sense?
Have you tried the example you provided. From your explanation,
that looks like it would work. You should only get rows returned
where an opportunityid exists in the nda table. If it doesn't, what
is wrong with the result set you get?
Regards, Stephen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
