Learning SQL

[Switchwork]

Why Sql????????

Hello

Is it easy to learn SQL????

and is something I really need to learn to use MS access???

I keep coming across SQL and am wondering what its all about.
I know that when you do a select query in access that access does all the SQL behind the scenes for you. So I am wanting to know for what reason would I need to learn SQL?????

I see that people enter there own SQL and want to know what reason they do this??? IS it better to do you own SQL and also how the hell do you learn all the stuff???

If someone could get back to me I would really appreciate it as I am really confused by this question???

THANX AND RESPECT!!!!!!

 

[pbaldy]

The Access QBE is a nice tool for building queries. It translates the SQL into a more visual format that's easier to understand when you're starting. However, there are certain more complicated queries that can't be represented in the QBE, such as union queries and non-equi joins.

You don't need to learn SQL, but it will make you a better developer in the long run. It's not difficult to learn the basics of it. One easy way to start is to build your queries in the QBE, then switch to SQL view and study the structure.

 

[Len Boorman]

What do you do if you want to Alter a table on the run so to speak. Okay this sort of this does ni=ot come up often but ....

as pbaldy says its not essential but there will come a time when wizards are not enough. Often as well if you are aware of the capabilities of SQL you can build more efficient and better applications.

Len B