Welcome to WebmasterWorld Guest from 54.226.46.6

Forum Moderators: open

Message Too Old, No Replies

MySQL - Large Criteria Requests

     

username

12:17 am on Mar 24, 2011 (gmt 0)

5+ Year Member



Hi,

I am required to setup a very complex database with a lot of fields. A standard query may look at 40 different fields in a table, then another 30 different fields in another table at the same time.

Is this possible?

For example, a psuedo-query might be:

SELECT FROM table1 WHERE (field1, field2, field7, field 9, field6, field40 ARE NOT EMPTY)

AND ALSO SELECT FROM table2 WHERE (value1, value2, value3, value11, value26, value27 ARE NOT EMPTY)

Because the field count and names are different is this possible to join or run these queries simultaneously?

Thanks in advance
 

Featured Threads

Hot Threads This Week

Hot Threads This Month