Database Question (Access SQL)

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

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

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.

U R Correct Genie

Kinjal

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

Thanks