Hi All

I have a 2 tables which related to each other
Nemaster(primary key is Oid) and
Elements (Neid reference Oid)

Now I have to run following query

A) SELECT IPADDRESS FROM ELEMENTS WHERE NEID = (SELECT OID FROM NEMASTER WHERE EID = &ID);

I can run the above query as below

B) SELECT IPADDRESS FROM NEMASTER A, ELEMENTS B
WHERE A.OID = B.NEID AND A.EID = @ID;

If my Nemaster table is going to be bulkier and if I am using above queries in FUNCTIONS then how I should call the query. By method A or B.

Amol