Database Question (Access SQL)

[-=XQ=-]

Sorry for the cross posting but I'm getting desperate!!!!

Can anybody help with these two database posts. One's nested select statements and the other is an error undefined function for a VB function I am trying to use in SQL.

http://www.vbforums.com/showthread.p...hreadid=200094
http://www.vbforums.com/showthread.p...hreadid=200078

[Genie]

On your first Question:

You can set aliases to tables in subqueries and perfix the alias to refer to nested table.

SELECT SomeFields
FROM FirstTable tA
WHERE tA.SomeFieldPrimaryKey = (SELECT tB.OtherFieldForeignKey
FROM OtherTable tB
WHERE ....)


The above works on an Oracle Db, not sure about Access.

[kinjalgp]

U R Correct Genie

Kinjal

[-=XQ=-]

Thankyou you've probably made me very happy I'll give it a go and post back if there is a problem.

Thanks