subject:"Help with a semi\-complex query"

Re: Help with a semi-complex query

2001-01-13 Thread Bob Hall

Sir, try GROUP BY test_name.name, build.name Bob Hall >I'm simplifying slightly, here's the basic tables: > >build >--- >idxint >name char(16) > >test_name > >idxint >name char(64) > >main_table > >idxint unsigned >test_name_idx medint >status

Help with a semi-complex query

2001-01-12 Thread Kingsbury, Michael

I'm simplifying slightly, here's the basic tables: build --- idx int namechar(16) test_name idx int namechar(64) main_table idx int unsigned test_name_idx medint status char build int swipchar(11) I want to do the follo