Thursday, February 16, 2006

some pictures & been busy doing some development..

photos taken out of boredom


i've been busy doing some app and now have to find out the way to join 3 tables with a single Structured Query Language (SQL)

after that.. i need to crack my head to update 3 tables simultaneously if changes are done or else update certain tables out of the 3 tables considering efficiency and resource usage.. -.-

5 comments:

n305er said...

erm... Joining 3 tables into 1?

Me joining 10 excel sheets database into 1 then process and filter them summore using Macro...

Lots of Loops involved... :P

Tiensoon said...

hm.. joining 3 tables should still be fine, and it's commonly seen in a normalized database structure. If outer join comes in, then it will be a little bit tedious, depending on the DBMS.

Remember to update more than 1 table simultaneously as a transaction, to ensure data consistency ;-)

@ロウ 。LOW@ said...

Bored? Try THIS. I'm pretty sure you'll like if you have not heard about it lol

Cheers!

Chuang Shyue Chou said...

Three table join! Hahahah. And you must write efficient statements that does not waste processor cycles! WOO HOO!

Go for it Alicia!

Alicia said...

darrenz : me always hv to do things with sql

n305er : i did it.. but the sql query is super long..

law : i found out the way to update them simultaneously with a just a line of sql :D

low : ~.~

csc : tired -.-