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:
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
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 ;-)
Bored? Try THIS. I'm pretty sure you'll like if you have not heard about it lol
Cheers!
Three table join! Hahahah. And you must write efficient statements that does not waste processor cycles! WOO HOO!
Go for it Alicia!
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 -.-
Post a Comment