This would be a much more powerful tool if it would pick up and apply the table alias back through the query i.e. at present I can type
select tblBankruptcySearch.BankruptcyAddress1 from tblBankruptcySearch as shortName
it would be good if it parsed to the beginning of the statement and changed it as so, otherwise I'd continue you to use the 'design query in editor' function within SQL, as it allows easy use of aliasing.
select shortName.BankruptcyAddress1 from tblBankruptcySearch as shortName
Thanks,
Cathal
select tblBankruptcySearch.BankruptcyAddress1 from tblBankruptcySearch as shortName
it would be good if it parsed to the beginning of the statement and changed it as so, otherwise I'd continue you to use the 'design query in editor' function within SQL, as it allows easy use of aliasing.
select shortName.BankruptcyAddress1 from tblBankruptcySearch as shortName
Thanks,
Cathal