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?
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?