Search results for query: *

Thanks PruSQLer. I found a similar solution here: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid543871_tax285649,00.html However, I have about a hundred different colors and am using Interbase/Firebird which does not have CASE or COALESCE. It appears I will...

Hello all, I have a flat file such as: Model Color A1 Black A1 White A1 Blue B2 White B2 Black B2 Yellow I need the data in a different horizontal flat file structure for usage with OSCommerce: Model Color1 Color2 Color3 A1 Black White...

If you want a display that looks like company recordCreator ---------------------- Microsoft ! swampBoogie, dbasch Microhard ! aleb, bleb I want a display that looks like: company recordCreator ---------------------- Microsoft ! swampBoogie Microhard ! dbasch Microflag ! powlin That is not...

> Which value from the recordCreator column should be chosen? All of them. Or, all that are distinct. I think you are thinking of a subquery. DISTINCT is a SELECT predicate and I am not using it in a subquery. I have tried to use subqueries to solve my issue but with no luck. I can only use...

Hello, I am trying to do a query such as: SELECT DISTINCT [Qualified Leads].[Company], [Qualified Leads].[Record Creator] FROM [Qualified Leads]; This returns all of the records that have fields taht are a combination of unique values. However, what I really need is just the company field to...