|
Posted by Zeno on 10/12/05 04:56
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_code(Primary key)
-Application_name
Applications_Installed
-Computer_name(Pri key)
-Application_code(Foreign key/sec key)
Workstation_info
-Computer_name(Pri 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_installed and
Workstation_info.
So I need to do a
Select * from applications where applications.application_code='XXX'
join (this is the part I'm stuck how do I tell it to match the
applications.application_code =
applications_installed.application_code) then match the computer names
from Applications_installed.computer_name with that of
workstation_info.computer_name
Not sure if I'm explaining this properly....
Can anyone help.......
Navigation:
[Reply to this message]
|