Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
robmays
Starting Member
3 Posts |
 Posted - 2005-04-19 : 06:29:45
|
| the query below gives me new row for every payer name. so if a job has 3 payers then i get 3 records returned, i only want to see one record returned with the payernames on the same row.SELECT Customers.Title, Customers.LastName, SaleItems.TypeOfJob, PhasePayers.PayerNameFROM SaleItems INNER JOIN Sales ON SaleItems.SaleID = Sales.SaleID INNER JOIN Customers ON Sales.CustomerID = Customers.CustomerID INNER JOIN PhasePayers ON SaleItems.PhaseID = PhasePayers.PhaseIDWhere SaleitemsID = 1234 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-04-19 : 08:46:25
|
| Have a look at this:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48152[/url]Mark |
 |
|
|
|
|
|
correlated queries please help