Is there a way to do this in one query???


SELECT Access.ID, Access.Name,Access.AccessURL,Access.AccessText
FROM Access
WHERE Access.ID = ${$rec}{'AccessID'}


and

SELECT AccessAlternates.AccessID, Access.Name, Access.AccessURL, Access.AccessText
FROM AccessAlternates, Access
WHERE AccessAlternates.LinkID = $id AND AccessAlternates.AccessID = Access.ID


In Words: I need

1. From Table Access ONE

ID | Name | AccessURL | AccessText

Where ID = field-value.

and

2. From Table Access all

ID | Name | AccessURL | AccessText

Where in Table AccessAlternates LinkID = $id

AccessID | LinkID

2 | 1
3 | 1
4 | 1

AND

ID | Name | AccessURL | AccessText

2 | Area1 | http...1 | Desc1
3 | Area2 | http...2 | Desc2
4 | Area3 | http...3 | Desc3


Or the second in words:

Get all AccessID from AccessAlternates for the $ID
and then get all fields from Access where ID = all AccessID


Humpf - is this understandable?

Im happy it runs now, but maybe someone could make this to one query instead two :-)

Robert