I've got three tables from the same database which are not related. In
each table there is a column called 'complete', which basically sets a
flag telling me whether a user has made an entry or not. I want to
select all rows where the column 'complete' has been set to 1 in each of
the three tables, to give me an overall figure.
e.g. table 1...complete is set to 1 on 5 rows
table 2...complete is set to 1 on 3 rows
table 3...complete is set to 1 on 2 rows
so the result I would be hoping for is a record count of 10.
I can't get either the syntax or the method correct. I'm using a web
front end, SQL Server version 7 (NT), and Cold Fusion as the middleware.
Has any got any ideas....much appreciated.