Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with SQL statement
Message
From
22/12/2003 19:12:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Help with SQL statement
Miscellaneous
Thread ID:
00861465
Message ID:
00861465
Views:
51
Hi ppl,

I need a little help with a sql statement

I have 8 fields like this q1a,q1b,q1c,q1d,q2a,q2b,q2c,q2d

each field is int()
values can be from 0 to 4

I need to only return a result set if 2 of the q1's values are greater than 2 or 2 of the q2's values are greater than 2

This will be running as a stored proc in SQL


Thanks in advance

Paul
Next
Reply
Map
View

Click here to load this message in the networking platform