-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|