We often use JOIN syntax for joining 2 or more tables in SQL. Such as INNER JOIN, OUTER JOIN, etc. But here I found another way of joining table that much like INNER JOIN, that is by tricking WHERE syntax.
Below is the example of INNER JOIN between table Customer and Member:
SELECT customer.name, member.name
FROM customer INNER JOIN member
ON customer.member_id = member.id
Here is the magic of using WHERE syntax:
SELECT customer.name, member.name
FROM customer, member
WHERE customer.member_id = member.id
Though the syntax doesn't look shorter enough, but it will be very handy for some SQL statement that joins a lot of tables.
This trick works fine with MySQL and HSQLDB. I haven't tried on another engine yet.
Tell me if i made a mistake. 
thanks
If you have Google Adsense, I bet you do know how hard it is to make money with it. You have to master all of webby things such as analyzing visitors, maintain your traffic, SEO, writing nice article, and a dozen of skills which to make your website a making money website.
Google Adsense is hard, but if you keep focus and learning how it works, making money is no more just like flapping your hand. Imagine how beautiful your life is by seeing those earning digits jumping everyday...
Here I want to share the fastest and the easiest way to make money with Google Adsense. But before that, you might want to see how much I have earned today. See the screenshot below:
Click here for the sake of your better life!
Update: Click here to see photos
Yesterday I was invited by Atek to go to Pulau Putri today. He also asked me to invite the others, the more the merrier. Well, I don't know what is he up to, suddenly invite all of us.
Today's weather is sunny, it's undoubtedly a great day for playing at the beach and adventuring. Pulau Putri, I never been there before. So I did a search and I found an article that wrote about Pulau Putri.
By the way, this is my third outbound to island outside Batam. The first time was to Belakangpadang with Nengsih (her hometown), Kristian, and some of my friends (ouch, I forgot some, it was 6 years ago). The second was to Pulau Panjang with Aheng, Apek, Atek, Jimmy, Michael, Stone, and Apek's parent.
2 hours more to go there soon...
I took these sunset scenes in last 4 months. Here I share:
Sunset on 14 Nov 2008
Sunset on 26 Dec 2008
Sunset on 23 Jan 2009
Sunset on 18 Feb 2009
