General

Re: How to query one coloumn of a Datasource twice? (SQL-Server)

123basti321 — Tue, 30 Sep 2008 14:52:14 GMT

Thanks! Well, now I get all out of the years 2008 and 2009 but cant filter anymore. (Well, exactly what the SQL-Query does do!)

Any other solutions?

Greeting

Re: How to query one coloumn of a Datasource twice? (SQL-Server)

Hari Krishna — Tue, 30 Sep 2008 13:45:49 GMT

Hi,

In the Data Connections go to "Edit SQL" and give the following query:

select "year" from "dbo"."TableName" as "TableName" where "year" in (2008,2009).

How to query one coloumn of a Datasource twice? (SQL-Server)

123basti321 — Tue, 30 Sep 2008 12:45:52 GMT

Hallo @all,

I want to do a query and i got a colloum called years. Now I want my repeating table to show all entries with 2008 or 2009. How could I manage to do so??(Excuse my bad English). What do I need to enter in the QueryField for the years coloumn?

Thanks a lot and I hope you do understand what I mean.

Greetings Basti