A diary dedicated to keep track of my interests in IT service management, administration and security, including project and knowledge management. Hopefully it will contain knowledge useful not only to myself, but also to others. Main focus is Windows and FreeBSD, and some OSX and Linux.
Wednesday, November 14, 2007
SQL queries
Today I made a view with a simple join, its very easy once you get the hang of it:
select b.column-name-1,a.column-name-2 from table1 a, table2 b where b.somecolumn = a.somecolumn
No comments:
Post a Comment