Duplication Help!!

[Yokiest]

Hello again with out this site i'd be lost.

Okay the question I have is this i have two tables that i join on an id
and then out put all the information.

table 1
id
name
status

table 2
id
state
service

now the way this works is that i have vendors on my site that i want to display what happens is it combines the table then in place out the information based on the status of the vendor where there active or not
the problem i have is some vendors are in more than one state or do more than just one service so what happens is there displayed 2 two 3 times
i was wondering if there was a way i could make it show only once.

[criterion9]

Have you tried using GROUP BY in your SQL statement?

[Yokiest]

yes i have and its grouped by state
but what i'm getting is

id = 3
name = Vendor
status = A
state = LV
service = cs

id = 3
name = Vendor
status = A
state = LV
service = rc

and its because the vendor does 2 things and not one and i'm trying to show all vendors in a state once and not 3 or 4 times

[ssystems]

Group it by vendor id