|
|
Posted by MVM on 10/05/06 13:49
Hi,
I am attempting to run a query in MS SQL server between two tables that have
a one to many relationship.
The tables are linked on GID. What I want is one instance of every record
from Table 1 even if there isn't a record in Table 2; and even if there are
multiple records in Table 2.
Table 1:
GID
Parcel
Name
Address
Table 2:
GID
Acres
I tried a left outer join, but it still returns multiple results because
there are multiple records for the same GID in table 2.
SELECT a.GID, a.Parcel, a.Name, b.Acres from
Table1 a LEFT OUTER JOIN Table2 b
ON a.GID = b.GID
I also tried using the DISTINCT keyword, but the problem is that the Acres
are different for every record in Table 2.
What query can I run to achieve my desired result?
Thanks a bunch,
MVM
Navigation:
[Reply to this message]
|