|
Registriert seit: 16. Jan 2004
Ort: Bendorf
5.219 Beiträge
Delphi 10.2 Tokyo Professional
|
AW: Firebird FIRST mit JOIN
27. Sep 2016, 10:14
So müsste es gehen:
Code:
SELECT
master10.*,
detail.*
FROM
(
SELECT FIRST 10
master.felder
FROM master
WHERE bedingung
) as master10
JOIN detail on detail.master_id = master10.id
WHERE bedingung
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."
|