query

Reply

Join Date: Nov 2007
Posts: 107
Reputation: kings has a little shameless behaviour in the past 
Solved Threads: 2
kings's Avatar
kings kings is offline Offline
Junior Poster

query

 
0
  #1
Mar 5th, 2008
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
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......
Reply With Quote Quick reply to this message  
Join Date: Dec 2007
Posts: 195
Reputation: mwasif is an unknown quantity at this point 
Solved Threads: 27
mwasif mwasif is offline Offline
Junior Poster

Re: query

 
0
  #2
Mar 5th, 2008
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



Tag cloud for MySQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC