Retrieve unique field in all tables

[babeo]

how to check all records of a unique field that located in any table of a database, eg
I have a field named "Johna" in all table a, table b, table f of database customer. It means in the out put of querying data, I should see something like this:

namealias table date otherfieldx
--------- ----- ---- -----------
Johna tablea Jan 1, 01 xxxx
Johna tableb Feb 15, 01 xxxxxx
Johna tablef Feb 20, 01 xx

Notes: I have tried with "datepart(datetime, namealias)", but getting error of "unknown field name namealias..."

Thanks