Subject | combining 2 left join |
---|---|
Author | dirinler |
Post date | 2008-11-05T08:03:03Z |
Hi there ;
Fb 2.1
i have 2 left join queries.how i can combine them or how i can use
them together?
[code]
GENELDETAIL1 LEFT JOIN SEVK ON
SEVK.GENELDETAILID=GENELDETAIL1.GENELDETAILID LEFT JOIN SEVKDETAIL ON
SEVKDETAIL.SEVKID=SEVK.ID
GENELDETAIL1 LEFT JOIN URETIM1 ON
URETIM1.GENDETAILID=GENELDETAIL1.GENELDETAILID LEFT JOIN
URETIMDETAIL1 ON URETIMDETAIL1.URETIMID=URETIM1.URETIMID
[/code]
Thanks.
Fb 2.1
i have 2 left join queries.how i can combine them or how i can use
them together?
[code]
GENELDETAIL1 LEFT JOIN SEVK ON
SEVK.GENELDETAILID=GENELDETAIL1.GENELDETAILID LEFT JOIN SEVKDETAIL ON
SEVKDETAIL.SEVKID=SEVK.ID
GENELDETAIL1 LEFT JOIN URETIM1 ON
URETIM1.GENDETAILID=GENELDETAIL1.GENELDETAILID LEFT JOIN
URETIMDETAIL1 ON URETIMDETAIL1.URETIMID=URETIM1.URETIMID
[/code]
Thanks.