|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
IS it possible to combine two queies to one.
Hi There!
I have 2 queries SELECT Distinct(parent_ID) FROM item_audits WHERE created>=date OR edited>=date SELECT Distinct(parent_ID) FROM item_responses WHERE created>=date Now i want to combine the above 2 queries to one query.is it possible? NOTE: all the refered fields are of datetime type Regards Bosky |
|
#2
|
|||
|
|||
|
Code:
SELECT parent_ID FROM item_audits WHERE created>=date OR edited>=date union SELECT parent_ID FROM item_responses WHERE created>=date |
|
#3
|
|||
|
|||
|
Thanks
Hey thank you so much. The statement fetches the exact result. The way i want it
![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > IS it possible to combine two queies to one. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|