Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL view
how can i get mutiple column values from multiple sql views?
Posted 12-Sep-12 21:14pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Learn JOINS in SQL and use it:
http://www.w3schools.com/sql/sql_join.asp[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Hi,
 
try like this,
SELECT V1.col1, V2.col2, V3.col3 FROM View1 V1 
INNER JOIN View2 V2 ON V1.Col1 = V2.Col1 
INNER JOIN View3 V3 ON V1.Col2 = V3.col3
 
hope it works.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

that was quite easy, i just created some views & joined them!
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.150302.1 | Last Updated 14 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100