querry, to put choosen ID´s together

[benjamin.grimm]

hey guys,

i have contracts with a Special ID.

Each ID has a sum of costs from SAP for each year,
a sum of cost from a System called geris for each year,
and earning for each year.

Now i want to put choosen ID´s together.

How can i do that?

Should i build a fake ID?

Here is my SQL Code

SELECT CCur(Nz([Benjamin],0)) AS SAP, CCur(Nz([Hans],0)) AS Geris, Abfrage_Zahlplan.Pauschale, UNION2.SuWID, UNION2.Jahr_Y, Tabelle_Vertrag.SAP_Nummer, [Tabelle_Kunden Stammdaten].BT_Name, Tabelle_Vertrag.Vertragsbeginn, Tabelle_Vertrag.Vertragsende, Tabelle_Vertrag.Anzahl_Fahrzeuge
FROM [Tabelle_Kunden Stammdaten] INNER JOIN (((UNION2 LEFT JOIN Abfrage_Diagramm ON (UNION2.SuWID = Abfrage_Diagramm.SuWID) AND (UNION2.Jahr_Y = Abfrage_Diagramm.Jahr_X)) LEFT JOIN Abfrage_Zahlplan ON (UNION2.SuWID = Abfrage_Zahlplan.SUWID) AND (UNION2.Jahr_Y = Abfrage_Zahlplan.Vertragsjahr)) INNER JOIN Tabelle_Vertrag ON UNION2.SuWID = Tabelle_Vertrag.SuWID) ON [Tabelle_Kunden Stammdaten].DebitorenID = Tabelle_Vertrag.DebID
WHERE (((UNION2.Jahr_Y) Is Not Null));

 

[Guus2005]

Chosen ID's? What do you mean?
Is it something which can be resolved using the IN keyword?

select ID, ...,... 
from table1
where ID IN (1,2,3,4,5,6,7,8,9)

or you can put the chosen ID's in a temporary table and run a query like:

select * 
from table1 
inner join tmpTable on Table1.ID = tmpTable.ID

HTH