Conditional database entries

suppish

New Member
How can I show only certain database entries that fulfill a certain criteria?
For example, I want to take the following table:

ClaimID ClientID BillingDate
1 1 March 12, 2010
2 2 June 3, 2010
3 1 January 5, 2008
4 3 February 9, 2011
5 2 May 19, 2005
6 1 November 20, 2005

and output this table:

ClaimID ClientID BillingDate
1 1 March 12, 2010
3 1 January 5, 2008
6 1 November 20, 2005

Based on a preset condition, in this case ClientID == 1.
How can I alter the output of the database and only show results that meet a condition?
 
Well, if this is an SQL database, you just need to code a select statement like this:

Select * from Claims where Client_ID = "1"
 
Top