Search results for query: *

I need to know how to do a SQL query in Access that does an outer join with another table...but here's the problem: The joined table needs to be qualified by date...i.e. I want the results set to show ALL records qualified in the main select statement (all locations by City found in 'British...

I am using the following query in a Cold Fusion page. The server says this is not a supported statement: "Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported." Here is the query: SELECT...

I want to filter or reduce my query results further based on only those records that have a count > some number. How can I use a subquery to do this? I have a ID column in table A and a table B that has Cat column and ID column that references table A ID column value. There are many records in...

How do you format a date in a query against a Access db? I need to know the function to use. In Oracle you have the TO_DATE(date,mask) function. What is the equivalent in Access land? Here is my query attempt that failed: SELECT * FROM classes WHERE TO_DATE(ClassDate,'mm/dd/yy') = TO_DATE(...

What tecnique do you use to remove duplicates? Let's say I have data set made up of the following columns: id subid userid 1 27 3872 2 32 3872 3 51 3872 4 16 4218 5 19 5211 The subid is an id for the magazine subscription for that user. But now...

Does anyone know of a good online source for a summary on how to use dates within MS SQL and Access 97. I'm trying to understand and learn the usage of dates while programming a Cold Fusion template using MS SQL queries to talk to a Access 97 db. MS does things the usual confusing way... Some...

I'm in need of an online reference to MS SQL Server supported functions I can use in my Cold Fusion queries to an Access 97 db. I can't get a simple select like the following to be accepted! SELECT date1, event, locname, city, state FROM rof_events WHERE date1 > 2001-04-01 Is lists all...