Help with a select

[nam797]

Hello All,

 

I am having a problem with a select statement. I am joining 3 tables and it is not showing correctly. I know it has something to do with my select statement. Here it is

 

SELECT VendCrews.CrewID, VendCrews.Company, VendCrews.Fax, VendCrews.City, VendCrews.Inactive, tblTrades.Trade, VendCrewCnts.Name
						FROM (VendCrews INNER JOIN VendCrewCnts ON VendCrews.CrewID = VendCrewCnts.CrewID) INNER JOIN (VendCrewsTrades INNER JOIN tblTrades ON VendCrewsTrades.TradeID = tblTrades.TradeID) ON VendCrews.CrewID = VendCrewsTrades.CrewID WHERE VendCrews.Inactive = 'Active' Group BY Company ORDER BY Company

 

Row Example

79

[/td]

[td]

A-1 Sheet Metal & Roofing, Inc.

NULL

NULL

Active

Roofing

John Deleski

 

Where it shows roofing there might be more than one(Roofing,siding,decks) that this subcontractor might do.

 

Thanks for the help

[fenway]

You can't use GROUP BY and get back multiple columns.

[nam797]

If i use DISTINCT i get the same results

[fenway]

If i use DISTINCT i get the same results

Of course you do... I didn't say anything about distinct.

[nam797]

Could you point me in the right direction on solving this?

[fenway]

Could you point me in the right direction on solving this?

Sure... let's take it from the top... what are you trying to display, and why do you have the group by?