By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

combining the results of two selects...

P: 2
Hi,

I have two similar but not exactly the same tables binding to gridviews in .net

i currently use two selects to get the data i need,

can I create a view or stored proc to combine the data and display on one gridview? (preferably sorted by xdate)

my sql is


Query1
SELECT id, gsm, pin, lat, long, xtime, Org, network, type, accuracy FROM lbspings WHERE (gsm = '') Or (gsm = '') Or (gsm = '') Or (gsm = '447814486282') Or (gsm = '') ORDER BY xtime DESC;

Query2
SELECT id, deviceid AS gsm, pin, Lat, Long, xtime, Placename AS Org, network, pingtype AS type, accuracy FROM gpspings WHERE (deviceid = '') Or (deviceid = '') Or (deviceid = '') Or (deviceid = '') Or (deviceid = '') ORDER BY xtime DESC;

I'm relatively new to mssql server and have wasted days on this...

Regards,

Laldie
Mar 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: 2
One of those moments,

SQL1

UNION ALL

SQL2

:-)

Laldie
Mar 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.