|
Posted by Stu on 10/12/05 05:44
Hey Zeno,
I think what you're looking for is:
SELECT columnlist
FROM Applications a JOIN Applications_Installed ai ON
a.Application_Code = ai.Application_Code
JOIN Workstation_Info wi ON ai.Computer_Name = wi.Computer_name
WHERE a.application_code = '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/detail/-/0672321289/103-8068006-7524660?v=glance
HTH,
Stu
Navigation:
[Reply to this message]
|