Re: Select

Thanks Stefan. Unfortunaltey that's when I notice that I'm just an SQL
beginner;)

If I run the query on the test data I get no results at all. Did you
get any results using this same query?

And where does the oid column come from?

Fritz

.

Relevant Pages

  • Re: Newbie: Help writing a sproc
    ... using the test data you posted earlie (changing the time on one row ... If you're sure you didn't make a mistake in copying the query, ... query will set the userid to NULL if the userid has at least one entry in ... So if userid 3 has an entry of 70 ...
    (microsoft.public.sqlserver.programming)
  • Re: Combo values based on query
    ... Thanks (The query won't always return a single ... netry - it's just that I had a small amount of test data. ... Try using the OnCurrent event of the form to Requery the Combo box. ... consider using a caculated field, ...
    (microsoft.public.access.formscoding)
  • Re: DBC mixed with Free tables performance
    ... I am currently working with test data so ... I am in the process of creating a database container for my free tables. ... are there any performance problems with mixing tables in ... I have a query that uses 4 tables to get some data. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Day of week queries
    ... > I have a tbale of employees and the day they work as follows: ... > been unable how to crossreference that function with the above data ... Execute the following Query: ... It needs more test data to make sure, ...
    (microsoft.public.access.queries)
  • Re: TRICKY SQL
    ... solving your query would be simple. ... CREATE VIEW BetterCarMovements ... DECLARE @EndDate datetime ... recreate your test data on my end, I didn't test the above query. ...
    (microsoft.public.sqlserver.server)