I have a database with 6 tables, each table has various fields, but all have 3 date fields in common (entryDate, modDate and delDate)
Does anyone know if there is a syntax where a VIEW can be created, leaving OUT those fields... but WITHOUT specifiy which fields to keep
the view is to contain only "active" records , i.e. those with a NULL delDate field
I would like to just pass the name of the data table to create the view
right now I have
SQL="CREATE VIEW view"+useTABLE+" As Select * FROM "+useTABLE+" WHERE delDATE Is NULL"
but obviously that keeps all the fields including the 3 common ones I don't need in the view