| | |
query
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
hi
i want to know how to fetch data by giving more than two condition...please tell me wat should i use
eg
i have a query
i want to know how to fetch data by giving more than two condition...please tell me wat should i use
eg
i have a query
SELECT * from post_resume WHERE ind_type='IT'and career='Engineering' order by tdate DESC i want to check based on another condition also...select association from employer where ownerid='34'; now i want to know how to combine all three condition into one query...... •
•
Join Date: Dec 2007
Posts: 195
Reputation:
Solved Threads: 27
You can use INNER JOIN if both tables have any field common.
We will be help you if you show us your both tables structure.
We will be help you if you show us your both tables structure.
![]() |
Similar Threads
- Sql Query (VB.NET)
- Removing Query Strings (ASP.NET)
- Double MySQL Query (PHP)
- Dynamic Query (JSP)
- MySQL nested query / joined query conversion help (MySQL)
- problem with lengthy query (Java)
- Retreiving variables from a sql query into a form (PHP)
- Query Building (Database Design)
Other Threads in the MySQL Forum
- Previous Thread: Understanding Syntax
- Next Thread: database query limitations
| Thread Tools | Search this Thread |
Tag cloud for MySQL
"use" 1 amazon api aws bizspark breathalyzer changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 eliminate email eudora facebook form foss gartner gnu government gpl groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlsearch news opendatabasealliance opengovernment opensource operand oracle pdf penelope php priceupdating query referencedesign remove reorderingcolumns results resultset search select simpledb sourcecode spotify sql statement sugarcrm syntax techsupport thunderbird transparency update virtualization





