Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
engcanada
Starting Member
39 Posts |
 Posted - 2011-12-30 : 18:24:43
|
| Can someone please help me combine these 2 select queries that have nothing in common. I am assuming UNION caluse is it?Please make sure OBDER BY in both queries are not ignored:SELECT top 20 ForumTopic.IdTopic, ForumTopic.Topic, ForumTopic.idTeacher, Forum.teacher, Forum.Feedback, Forum.dateforum, Forum.idfeedback, Forum.allow FROM Forum INNER JOIN ForumTopic ON Forum.IdTopic = ForumTopic.IdTopic where allowtopic=1 order by dateforum descSELECT top 20 title, salary, moneda, idjob, country, dateposted, details from SCHOOL where status='0' order by dateposted descThank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
engcanada
Starting Member
39 Posts |
Posted - 2011-12-30 : 19:22:58
|
| I am trying to pick the most recent record regardless of the TABLES and, have it come on up in a RSS feed application. |
 |
|
|
engcanada
Starting Member
39 Posts |
Posted - 2011-12-30 : 19:25:45
|
| I don t want to create 2 seperate feeds.cheers |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
whatamouth
Starting Member
16 Posts |
Posted - 2012-01-03 : 04:12:30
|
| use full outer join insteadNeil Matiasneilmatias@yahoo.com |
|
|
|
|
|
|
|
|
Help with UNION