when to do a JOIN?

[sammy182]

Hi,
In Access you can do joins in the database, and in SQL you can do joins in the code. When is a good time to do the join? Both?

[big_al]

When you are JOINING more than one table to eachother by refence to a value in one of the table.

i.e. if you have a Unique indetifier from one table that you use to identify a record in another table


Hope that helps

[sammy182]

Sorry,
I worded my question really poorly...
In ASP when you join tables is it done in SQL or Access?

[big_al]

You can use JOIN on either of them

[sammy182]

Really? And they both work the same when doing Queries?

[big_al]

Depending on the query.

Not all query's will work from SQL to Access and vice versa.

it all depends on the complexity of the query.

With Access you can actualy be lazy and create a query in the gui Access gives you and then query that query as if where a table from your Script

[m1l]

Or you could be lazy by creating the query in Access and when you are finished, grab the SQL by clicking the view button (probably left most button in Access) and choose SQL View and copy the SQL out of there and paste into ASP.

[SpyderMan]

Access and SQL can do joins, but access sql and MS SQL Server sql isn't compatible in most cases. MS SQL supports a more advanced set of functions and joins, but dont copy access code to sql.

Use the Query Analyser to build MS SQL queries, it's harder to learn, but there are great help files accesible from the menu.