Join statement

[Zeno]

Hi.........

Its been awhile since I've touched SQL statements, so I need some help
with writing a JOIN statement to query 3 tables.

The dB has 3 tables with values
Applications
-Application_cod e(Primary key)
-Application_nam e

Applications_In stalled
-Computer_name(P ri key)
-Application_cod e(Foreign key/sec key)

Workstation_inf o
-Computer_name(P ri key)
-Serial_number

What I want to do is query the tables for a particular Application code
and name from Applications, so that it returns the values of computer
names with the matching values from Applications_in stalled and
Workstation_inf o.

So I need to do a

Select * from applications where applications.ap plication_code= 'XXX'
join (this is the part I'm stuck how do I tell it to match the
applications.ap plication_code =
applications_in stalled.applica tion_code) then match the computer names
from Applications_in stalled.compute r_name with that of
workstation_inf o.computer_name

Not sure if I'm explaining this properly....

Can anyone help.......

[Stu]

Hey Zeno,

I think what you're looking for is:

SELECT columnlist
FROM Applications a JOIN Applications_In stalled ai ON
a.Application_C ode = ai.Application_ Code
JOIN Workstation_Inf o wi ON ai.Computer_Nam e = wi.Computer_nam e
WHERE a.application_c ode = 'XXX'

May I also suggest that you pick up a reference guid on basic SQL;
newsgroups can be harsh teachers :) Years ago, I found Ben Forta's 10
Minute Guide very good at covering the basic concepts:

http://www.amazon.com/exec/obidos/tg...24660?v=glance

HTH,
Stu

[Zeno]

Thanks Stu.........

I'll give it a try and let you know how things go............
Cheers

[Zeno]

Thanks Stu.........

I'll give it a try and let you know how things go............
Cheers

[aaron.kempf]

use ACCESS DATA PROJECTS they allow you to drag and drop fields around
instead of getting frustrating writing queries.

TSQL is too hard to just dive into -- use ADP as a crutch to help you
to start getting things done and stop worrying about syntax.

[Erland Sommarskog]

(aa*********@gm ail.com) writes:

use ACCESS DATA PROJECTS they allow you to drag and drop fields around
instead of getting frustrating writing queries.

TSQL is too hard to just dive into -- use ADP as a crutch to help you
to start getting things done and stop worrying about syntax.

I would say that this is a poor advice in the long run. Maybe if you
only compose a query once or twice a year maybe. But else learning
SQL syntax pays off.

And using Access may not necessarily be helpful, since there are
significant differences between the SQL in Access and Transact-SQL.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp