SQL query to select records from three Tables seperatly
Posted
by Azhar
on Stack Overflow
See other posts from Stack Overflow
or by Azhar
Published on 2010-04-15T13:43:52Z
Indexed on
2010/04/15
13:53 UTC
Read the original article
Hit count: 138
sql
|sql-server-2005
SQL query which select the record from three tables and there is no relation between these tables. Actually I want to make it a VIEW.
suppose there are three tales Table1, Table2, Table3
I want to show records of Table1 first with some filter criteria and then the records from Table2 and in last from Table3 as when we execute the view it show like the records like a Table.
There can be any number of rows but the records must be in this sequence.
© Stack Overflow or respective owner