|
Registriert seit: 16. Jan 2004
Ort: Bendorf
5.219 Beiträge
Delphi 10.2 Tokyo Professional
|
Re: SQL Abfrage über 3 Tabellen
30. Nov 2009, 15:38
Hi,
Vielleicht so:
EDIT: Verbessert:
SQL-Code:
SELECT
hsrp.id,
hsrp.hsrp,
site.site,
site.sitenr,
subnets.vlan
FROM site
JOIN hsrp on (hsrp.site_id = site.id)
LEFT OUTER JOIN subnets on ((subnets.site_id = site.id) and (subnets.hsrp = hsrp.hsrp))
Habs aber nicht getestet. Funktioniert!
Michael "Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination,
but because their imagination reveals worlds that others cannot see."
|
|
|
Zitat
|