Two Querries In One
Apr 14, 2006i have this two simillar querries :
SELECT allgestiuni.numegest, iesiri.nrdoc
FROM ((iesiri JOIN intrari ON ((iesiri.lotid = intrari.idlot)))
JOIN allgestiuni ON ((intrari.gestid = allgestiuni.idgest)))
WHERE (iesiri.tipdoc= 'tvliv') AND
(iesiri.nrdocsec like 'validat')
and
SELECT allgestiuni.numegest, iesiri.nrdoc
FROM ((iesiri JOIN intrari ON ((iesiri.nrdoc=intrari.nrdoc)))
JOIN allgestiuni ON ((intrari.gestid = allgestiuni.idgest)))
WHERE (iesiri.tipdoc = 'tvliv') AND
(iesiri.nrdocsec like 'validat')
as you see the querries returns the same columns only the
first join differs.
I want this two querries in one querry that will display
4 columns with data