Shoutistics
255,967
Total Shouts
29
Last 24 Hours
Leaderboard


The Shoutbox

Dude I have the honor of being the oldest regular MoFo I think... unless Patti has me beat by a few months

Access is very limiting...I mean it's nothing more than A GUI overlay to generate SQL code. I bypass the middle man frequently. I use Crystal alot to generate queries... the built in math functions are killer

Bah, I'm much more comfortable with the other side of things...messin' with the data once it's retrieved. String manipulation is HEAVEN! So much fun.

Yeah, I think I see what you're saying. Blast, I can't stand Access sometimes. I wouldn't be able to handle getting used to it all over again.

Yeah... SELECT, FROM, WHERE, ORDER By, UPDATE etc is straight SQL. It gets kinky applying mathematical formulas to it...

Should be identical. I'm studying SQL Server 7.0 and the commands are the same...as expected. Look at one of your old DB's in the query section and where you toggle from design to layout view there is a small arrow... click on that and you can watch the SQL being generated

I've used joins and junk, but MySQL, thankfully, has, as you can see below, an easier way of handling them...which I REALLY appreciate. 


A little like this...
SELECT u.username, t.title. f.title AS f_title FROM forum f, title t, user u WHERE f.forumid = t.forumid AND u.userid = t.userid ORDER BY t.timestamp DESC LIMIT 10
SELECT u.username, t.title. f.title AS f_title FROM forum f, title t, user u WHERE f.forumid = t.forumid AND u.userid = t.userid ORDER BY t.timestamp DESC LIMIT 10