need help on DISTINCT

[Krechting]

Hi ALl,

I need some help on DISTINCT in a query I'm trying to run.
I have two tables which are linked. This is the query I use:

SQL = "SELECT DISTINCT name, category, land, task, nbc_protect,
airportable, amphebian, alternative, capacity_fuel, crew, height,
length, width, range_max, range_eff, range_cruise, speed_road,
terrain_water, speed_terrain, calibre, rate_of_fire, weight,
penetration, type_ammo, diameter, radius_casualty, type_fuse,
type_grenade, traverse, num_rotor_blades, num_barrels, altitude_max,
pressure, charge, max_speed_air, ceiling, datum_invoer,
datum_controle, time_controle, weaponkey, ImagePathAndFile " & _
"FROM Weapon INNER JOIN Images ON Weapon.WID = Images.IID"
Order = "name"

The Table Weapon has a autonumber (WID) which is linked to the IID in
Images.
There are several recs in Weapon which have more then one picture
linked to it.
The way it is now I see these records several times in the query
results.

I want them to show up only once. What do I have to alter here?

Regards
Marco

[Aaron Bertrand [MVP]]

So, what do you want, any arbitrary image from the Images table?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Krechting" <m.krechting@chello.nl> wrote in message
news:a71c776d.0401111322.36869a13@posting.google.c om...

> Hi ALl,
>
> I need some help on DISTINCT in a query I'm trying to run.
> I have two tables which are linked. This is the query I use:
>
> SQL = "SELECT DISTINCT name, category, land, task, nbc_protect,
> airportable, amphebian, alternative, capacity_fuel, crew, height,
> length, width, range_max, range_eff, range_cruise, speed_road,
> terrain_water, speed_terrain, calibre, rate_of_fire, weight,
> penetration, type_ammo, diameter, radius_casualty, type_fuse,
> type_grenade, traverse, num_rotor_blades, num_barrels, altitude_max,
> pressure, charge, max_speed_air, ceiling, datum_invoer,
> datum_controle, time_controle, weaponkey, ImagePathAndFile " & _
> "FROM Weapon INNER JOIN Images ON Weapon.WID = Images.IID"
> Order = "name"
>
> The Table Weapon has a autonumber (WID) which is linked to the IID in
> Images.
> There are several recs in Weapon which have more then one picture
> linked to it.
> The way it is now I see these records several times in the query
> results.
>
> I want them to show up only once. What do I have to alter here?
>
> Regards
> Marco