| Author |
Topic |
|
phrankbooth
Posting Yak Master
162 Posts |
 Posted - 2007-09-19 : 12:03:46
|
| Hi again,I'd appreciate advice on the following. Thanks very much!Given this Table:family|product|typefam1 |abc |XXfam1 |def |YYWhat query would return this?Family|Type1|Type2fam1 |xx |yy--PhB |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
phrankbooth
Posting Yak Master
162 Posts |
Posted - 2007-09-19 : 12:22:01
|
| Thanks for the quick reply!That page shows a lot of stuff I don't need, I just want a simple query. Is it safe to say that the COALESCE command is the one that does what I need?Also, family field is not necessarily the key.Thanks!--PhB |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 12:30:53
|
What is then?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
phrankbooth
Posting Yak Master
162 Posts |
Posted - 2007-09-19 : 12:40:20
|
| Just want a query result to be this:fam1,xx,yyThe pipes were just there are visual field separators.Just want query results to show on one line instead of two.--PhB |
|
|
|
Kristen
Test
22859 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 12:42:05
|
Brett showed you a solution.Don't you care finding it?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
phrankbooth
Posting Yak Master
162 Posts |
|
|
|
Single row result from mutliple table rows?