homepage Welcome to WebmasterWorld Guest from 54.145.172.149
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MySQL - Large Criteria Requests
username

5+ Year Member



 
Msg#: 4286597 posted 12:17 am on Mar 24, 2011 (gmt 0)

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

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved