Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

HowTo: Comparing two tables and returning the # of rows that match FAST

by Jason L Froebe on February 15, 2013, no comments

The most intuitive way to write a comparison of two tables and spit out the # of rows that are the same involves a left join: select ‘Investment’ as TableName, count(*) as RowCount from Investment_A a, Investment_B b where a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = b.col3 AND a.col4 = b.col4 This [...]

Share Button

FW: WordPress vs. Drupal: Not that it’s about winning

by Jason L Froebe on April 16, 2008, 2 comments

Selena over at Tending the Garden, posted a very good video of why you would choose WordPress or Drupal. It seems a little slanted towards Drupal but that may just be me

Share Button
Facebook login by WP-FB-AutoConnect